ClickHouse

The analytics database behind PostHog and Plausible

clickhouse.com · OSS free; Cloud usage-based

ClickHouse: columnar OLAP database answering billion-row aggregations in milliseconds — the engine every analytics product is built on.

Capabilities

Best for

  • Cloning analytics products (event pipelines, dashboards over huge event tables)

Not for

  • Transactional app data (wrong shape; use Postgres)