Skip to content
Dev Tools Library

ClickHouse

Ultra-fast columnar database for large-scale analytics.

DatabaseOpen source
Open site(opens in a new tab)Repository(opens in a new tab)

Columnar database for analytical (OLAP) queries over billions of rows in real time, used for metrics, logs and events.

When to use

For analytics and dashboards over large volumes of events and logs.

When to avoid

For transactional workloads with many point updates; use a relational database.

Alternatives

They do a similar job. Compare before choosing.

  • DuckDB

    SQLite for analytics: a fast embedded analytical database.

    DatabaseOpen source★ 42.7K

Related

From the same area, with a close purpose.

  • Metabase

    Open source BI: questions and dashboards without writing SQL.

    AppOpen source★ 50K

  • dbt

    Data transformations in SQL with tests and documentation.

    CLIOpen source★ 14.1K