{"repo":"ClickHouse/JSONBench","free":true,"listed":false,"github":"https://github.com/ClickHouse/JSONBench","clone":"git clone https://github.com/ClickHouse/JSONBench.git","description":"JSONBench: a Benchmark For Data Analytics On JSON","language":"Shell","stars":183,"topics":["analytics","benchmark","clickhouse","database","duckdb","elasticsearch","json","mongodb","postgresql","sql"],"license":null,"category":"databases-storage","readme_excerpt":"JSONBench: A Benchmark For Data Analytics on JSON Overview This benchmark compares the native JSON support of the most popular analytical databases. The dataset is a collection of files containing JSON objects delimited by newline (ndjson). This was obtained using Jetstream to collect Bluesky events. The dataset contains 1 billion Bluesky events and is currently hosted on a public S3 bucket. We wrote a detailed blog post about JSONBench, explaining how it works and showcasing benchmark results for five databases: ClickHouse, MongoDB, Elasticsearch, DuckDB, and PostgreSQL. Principles The main principles of this benchmark are: Reproducibility It is easy to reproduce every test in a semi-automated way (although for some systems it may take from several hours to days). The test setup is documented and uses inexpensive cloud VMs. The test process is available in the form of a shell script, covering the installation of each database, loading of the data, running the workload, and collecting the result numbers. The dataset is published and made available for download in multiple formats. Realism The dataset represents real-world production data. The realistic data distribution allows to account appropriately for compression, indices, codecs, custom data structures, etc., something that is not possible with most random data generators. JSONBench tests various aspects of the hardware as well: some queries require high storage throughput, some queries benefit from a large number of CPU","default_branch":null,"files":null,"tree":[],"storefront":"/r/ClickHouse","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/ClickHouse/JSONBench/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}