SaaSHub helps you find the best software and product alternatives Learn more โ
ClickBench Alternatives
Similar projects and alternatives to ClickBench
-
hosts
๐ Consolidating and extending hosts files from several well-curated sources. Optionally pick extensions for porn, social media, and other categories.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
-
-
prql
PRQL is a modern language for transforming data โ a simple, powerful, pipelined SQL replacement
-
Apache Arrow
Apache Arrow is the universal columnar format and multi-language toolbox for fast data interchange and in-memory analytics
-
-
-
-
databend
๐๐ฎ๐๐ฎ, ๐๐ป๐ฎ๐น๐๐๐ถ๐ฐ๐ & ๐๐. Modern alternative to Snowflake. Cost-effective and simple for massive-scale analytics. https://databend.com
-
hydra
Hydra: Column-oriented Postgres. Add scalable analytics to your project in minutes. (by hydradatabase)
-
-
-
-
-
-
-
-
starrocks
The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
-
ClickBench discussion
ClickBench reviews and mentions
-
7 Databases in 7 Weeks for 2025
> Clickhouse benchmarks donโt show Pinot favorably by comparison
Looks like they don't configure any indexes for Pinot in their benchmarks, which is one of Pinot's main selling points on the performance front - https://github.com/ClickHouse/ClickBench/issues/37.
- Building Observability with ClickHouse
- ClickBench โ A Benchmark for Analytical DBMS
-
pg_duckdb: Splicing Duck and Elephant DNA
Very much agreed with this general idea, and believe a lot of this was inspired by the team we hired at Crunchy Data to build it as they were socializing it for a while. Looking forward to pg_duckdb advancing in time for now it still seems pretty early and has some maturing to do. As others have said, it needs to be a bit more stable and production grade. But the opportunity is very much there.
We recently submitted our (Crunchy Bridge for Analytics-at most broad level based on same idea) benchmark for clickbench by clickhouse (https://benchmark.clickhouse.com/) which puts us at #6 overall amongst managed service providers and gives a real viable option for Postgres as an analytics database (at least per clickbench).
- Ask HN: State of Timeseries Databases in 2024
-
DuckDB Meets Postgres
What is your use case? If you're considering pg_analytics, I would suggest you check out pg_lakehouse. It's even more performant than pg_analytics, see here: https://github.com/ClickHouse/ClickBench/pull/208
-
Why Apache Doris is the Best Open Source Alternative to Rockset
Row/column hybrid storage: Apache Doris is a column-oriented data warehouse that achieves world-leading OLAP performance on ClickBench. Additionally, it supports row-oriented storage to serve high-concurrency point query scenarios, which allows it to respond to almost a million query requests within milliseconds.
-
Pg_lakehouse: Query Any Data Lake from Postgres
You can see performance comparison to Hydra on ClickBench: https://benchmark.clickhouse.com/ by selecting ParadeDB and Hydra. Tl;dr: It is much faster.
From a feature-set perspective, in addition to querying local disk, we can query remote object stores (S3, GCS, etc.), table format providers (Delta Lake, soon Iceberg too).
From a code perspective, we're written in Rust on top of open-source standards like OpenDAL and DataFusion, while Hydra is their own codebase built from a fork of Citus columnar, in C.
Hydra is a cool project. Hope this helps! :)
-
Umbra: A Disk-Based System with In-Memory Performance [pdf]
Benchmarks: https://benchmark.clickhouse.com
So definitely compared against PostgreSQL, MariaDB it is significantly faster.
On par with lower-end Snowflake.
- Loading a trillion rows of weather data into TimescaleDB
-
A note from our sponsor - SaaSHub
www.saashub.com | 7 Dec 2024
Stats
ClickHouse/ClickBench is an open source project licensed under GNU General Public License v3.0 or later which is an OSI approved license.
The primary programming language of ClickBench is HTML.