ClickHouse

ClickHouse is a columnar database management system tailored for real-time analytics on large volumes of data. Unlike row-oriented databases such as PostgreSQL or MySQL, it optimises for high-speed analytical queries by storing data in columns, enabling efficient compression and vectorised execution. Its distributed architecture supports scaling out to handle petabytes of data, making it suitable for big data environments where query latency is critical. ML and AI engineers benefit from its ability to quickly aggregate and filter massive datasets, which aids feature engineering and model evaluation. With over 45,000 stars and active development as of early 2026, it is mature and widely adopted. However, it is not designed for transactional workloads or complex relational operations, so teams requiring full ACID compliance or heavy OLTP should consider alternatives like CockroachDB or PostgreSQL instead.

Choose ClickHouse when you need fast, scalable analytics on large datasets with real-time query performance, especially for event data or time series. If your use case involves transactional consistency or complex joins, consider PostgreSQL or Snowflake, which offer stronger transactional guarantees or managed cloud analytics respectively.

ClickHouse is typically deployed in analytics platforms for monitoring, business intelligence dashboards, or log aggregation systems. It also suits data engineering pipelines that require fast ad hoc querying over event streams or telemetry data, such as internal observability tools or customer behaviour analysis.

Latest commit: 2026-01-11. Activity data is based on daily RepoPi snapshots of the GitHub repository.