SaaSHub helps you find the best software and product alternatives Learn more →
ClickHouse Alternatives
Similar projects and alternatives to ClickHouse
-
PostgreSQL
Mirror of the official PostgreSQL GIT repository. Note that this is just a *mirror* - we don't work with pull requests on github. To contribute, please see https://wiki.postgresql.org/wiki/Submitting_a_Patch
-
InfluxDB
InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
-
Plausible Analytics
Simple, open source, lightweight and privacy-friendly web analytics alternative to Google Analytics.
-
Matomo
Empowering People Ethically 🚀 — Matomo is hiring! Join us → https://matomo.org/jobs Matomo is the leading open-source alternative to Google Analytics, giving you complete control and built-in privacy. Easily collect, visualise, and analyse data from websites & apps. Star us on GitHub ⭐️ – Pull Requests welcome!
-
-
prql
PRQL is a modern language for transforming data — a simple, powerful, pipelined SQL replacement
-
materialize
Real-time Data Integration and Transformation: use SQL to transform, deliver, and act on fast-changing data. (by MaterializeInc)
-
PostHog
🦔 PostHog provides open-source web & product analytics, session recording, feature flagging and A/B testing that you can self-host. Get started - free.
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
-
TimescaleDB
A time-series database for high-performance real-time analytics packaged as a Postgres extension
-
-
-
tsbs
Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data
-
-
redpanda
Redpanda is a streaming data platform for developers. Kafka API compatible. 10x faster. No ZooKeeper. No JVM!
-
-
-
highlight
highlight.io: The open source, full-stack monitoring platform. Error monitoring, session replay, logging, distributed tracing, and more.
-
-
-
-
-
SaaSHub
SaaSHub - Software Alternatives and Reviews. SaaSHub helps you find the best software and product alternatives
NOTE:
The number of mentions on this list indicates mentions on common posts plus user suggested alternatives.
Hence, a higher number means a better ClickHouse alternative or higher similarity.
ClickHouse discussion
ClickHouse reviews and mentions
Posts with mentions or reviews of ClickHouse.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2025-05-14.
-
How to Build a Streaming Deduplication Pipeline with Kafka, GlassFlow, and ClickHouse
ClickHouse: A fast columnar database. It will be our final destination for clean data. And, for simplicity in this tutorial, we'll cleverly use it as our "memory" or state store to remember which events we've already seen recently.
- Waiting for Postgres 18: Accelerating Disk Reads with Asynchronous I/O
-
Why You Shouldn’t Invest In Vector Databases?
In fact, even in the absence of these commercial databases, users can effortlessly install PostgreSQL and leverage its built-in pgvector functionality for vector search. PostgreSQL stands as the benchmark in the realm of open-source databases, offering comprehensive support across various domains of database management. It excels in transaction processing (e.g., CockroachDB), online analytics (e.g., DuckDB), stream processing (e.g., RisingWave), time series analysis (e.g., Timescale), spatial analysis (e.g., PostGIS), and more. For non-professional users seeking to explore vector databases, they can readily download the open-source PostgreSQL or utilize managed services like Supabase and Neon to establish their own basic AI applications. Other than PostgreSQL, several open-source databases, including OpenSearch, ClickHouse, and Cassandra, have implemented their own vector search functionality. You do not need to adopt a new vector database if you have already used these systems.
-
Reproducing Hacker News writing style fingerprinting
https://gh-api.clickhouse.tech/play?user=play#U0VMRUNUICogRl...
I subscribe to this issue to keep up with updates:
https://github.com/ClickHouse/ClickHouse/issues/29693#issuec...
And ofc, for those that don't know, the official API https://github.com/HackerNews/API
-
Modern CMake
https://github.com/ClickHouse/ClickHouse
We are trying to use CMake in a very limited fashion.
For example, any build time environment checks are forbidden (no "try_compile" scripts), and all configuration for all platforms is fixed.
We don't use it for installation and packaging; it is only used for builds. The builds have to be self-contained.
From this standpoint, there should be no big difference between CMake, Bazel, Buck, GYP, GN, etc.
-
Cloudflare R2 Data Catalog: Managed Apache Iceberg tables with zero egress fees
curl https://clickhouse.com/ | sh
-
Twitter's 600-Tweet Daily Limit Crisis: Soaring GCP Costs and the Open Source Fix Elon Musk Ignored
ClickHouse: ClickHouse is an open-source columnar database management system designed for high-performance analytics. It excels at processing large volumes of data and offers real-time querying capabilities. It’s probably the world’s fastest real-time data analytics system: ClickHouse Benchmark.
-
Exposing concurrency bugs with a custom scheduler
It is possible to do this entirely in userspace without a custom scheduler.
See the implementation here: https://github.com/ClickHouse/ClickHouse/blob/master/src/Com...
It works and makes significant improvements for the detection of concurrency bugs, including complex logical races in distributed scenarios.
-
How about trailing commas in SQL?
ClickHouse has support for trailing commas for several years.
I recommend looking at ClickHouse (https://github.com/ClickHouse/ClickHouse/) as an example of a modern SQL database that emphasizes developer experience, performance, and quality-of-life improvements.
I'm the author of ClickHouse, and I'm happy to see that its innovation has been inspired and adopted in other database management systems.
-
DeepSeek's Data Breach: A Wake-Up Call for AI Data Security
Further investigation revealed that these ports provided direct access to a publicly exposed ClickHouse database—entirely unprotected and requiring no authentication. This discovery raised immediate security concerns, as ClickHouse is an open-source, columnar database management system designed for high-speed analytical queries on massive datasets. Originally developed by Yandex, ClickHouse is widely used for real-time data processing, log storage, and big data analytics—making such an exposure particularly sensitive and valuable from a security standpoint.
-
A note from our sponsor - SaaSHub
www.saashub.com | 24 May 2025
Stats
Basic ClickHouse repo stats
243
40,799
10.0
1 day ago
ClickHouse/ClickHouse is an open source project licensed under Apache License 2.0 which is an OSI approved license.
The primary programming language of ClickHouse is C++.
Sponsored
InfluxDB – Built for High-Performance Time Series Workloads
InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.
www.influxdata.com