ClickHouse
Column-oriented database for analytics
Databases / Data · Apache-2.0 · 50.5k
Reviewed 2026-08-19 · last push 2026-10-21 · repo checked 2026-10-21
What's Good
Analytics queries that would take minutes in Postgres complete in seconds. Column-oriented storage is perfect for time-series and event data. Compression is aggressive. The SQL dialect is familiar.
The Catch
Not a general-purpose database—updates and deletes are expensive. Operational complexity for self-hosting. The learning curve for optimal schema design is steep.
Verdict
The analytics database when Postgres is too slow.
Embed
Maintainer? Add the badge to your README. It is free, links to this review, and there is no paid version.
Markdown
[](https://stackgems.com/gems/clickhouse)
HTML
<a href="https://stackgems.com/gems/clickhouse"><img src="https://stackgems.com/badge/clickhouse.svg" alt="ClickHouse reviewed on Stack Gems" height="20"></a>