Show HN: A benchmark for analytical databases (Snowflake, Druid, Redshift)

• ClickBench

  68 559 9.1 HTML

  ClickBench: a Benchmark For Analytical Databases

  

  Benchmarks can be quite difficult to interpret when the test parameters vary between tests. However, I think the point in providing the open-source ClickBench benchmark [https://github.com/ClickHouse/ClickBench] is exactly to allow users to do their own research in providing a standardized client and workload across any SQL-based DBMS. Standardized benchmarking is an important technique, for comparing across different applications, or also for comparing the same application across different environments (compute, storage, cloud vs. self-managed, etc.). SPEC [https://www.spec.org] used to do a great job in developing and releasing standardized benchmarks, although their activity has waned of late

• TablePlus

  54 3,186 0.0

  TablePlus macOS issue tracker

  

  Clickhouse support for Tableplus landed 2 months ago. https://github.com/TablePlus/TablePlus/issues/670

• InfluxDB

  www.influxdata.com

  sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• clickhouse-bulk

  1 460 5.3 Go

  Collects many small inserts to ClickHouse and send in big inserts

  Thanks!

  I remember trying the built-in batching but we had some trouble with it, so we just switched to <https://github.com/nikepan/clickhouse-bulk> which works without any issue since then.

  Will have a look at the UIs listed there

• starrocks

  12 7,684 10.0 Java

  StarRocks, a Linux Foundation project, is a next-generation sub-second MPP OLAP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics, and ad-hoc queries. InfoWorld’s 2023 BOSSIE Award for best open source software.

  

  Full disclosure - I work for StarRocks (starrocks.com)

  First of all, this is great. Transparent and healthy competition is always great for the customers!

  Regarding the joined table queries that are missing in the tests, this is exactly why we built StarRocks - to give people the best performance of complex analytics queries on both joined tables and single tables.

  I encourage you to checkout this blog: https://starrocks.medium.com/starrocks-outperforms-clickhous...

  And, give us a star if you think we are doing the right thing: https://github.com/StarRocks/starrocks

  Follow us on LinkedIn for the latest updates: https://www.linkedin.com/company/starrocks

• ClickHouse

  208 33,909 10.0 C++

  ClickHouse® is a free analytics DBMS for big data

  

• duckdb

  52 16,356 10.0 C++

  DuckDB is an in-process SQL OLAP Database Management System

  

Suggest a related project