ClickHouse: columnar OLAP database answering billion-row aggregations in milliseconds — the engine every analytics product is built on.
ClickHouse
The analytics database behind PostHog and Plausible
clickhouse.com · OSS free; Cloud usage-based
Capabilities
Best for
- Cloning analytics products (event pipelines, dashboards over huge event tables)
Not for
- Transactional app data (wrong shape; use Postgres)