ClickHouse
An open-source column-oriented OLAP database management system supporting a vectorized execution engine, capable of sub-second aggregation queries across trillions of rows. It is commonly used for large-scale web crawl data storage and analysis.
Core Facts
ClickHouse is a high-performance columnar analytical database that uses a columnar storage architecture where data is organized on disk by column rather than by row.
Langfuse includes components such as a Web interface, PostgreSQL, Redis, ClickHouse, and a Langfuse Worker responsible for asynchronous evaluation.
Timeline (last 90 days)
Nike's observability platform is based on Grafana and ClickHouse, processing about 200TB of data per day.
The skeleton of frontend monitoring is divided into the collection layer, transport layer, storage layer, and alerting layer, among which the storage layer typically uses a columnar database such as ClickHouse.
DuckDB and cluster-deployment solutions like ClickHouse and Doris are complementary rather than substitutes.
Flagsmith Experiments allows users to connect their own ClickHouse or Databricks instances, while also offering a hosted repository option.
Postman introduced schema-aware read-only access to ClickHouse tables for structured data.
Systems such as ClickHouse, Amazon Redshift, Google BigQuery and Snowflake are designed specifically for OLAP scenarios.
He-API's usage events are written to ClickHouse via Kafka, while billing, model and provider metadata land in PostgreSQL; the system comprises 15 services running on systemd, all in Go except one Next.js admin console; the middleware includes Postgres, Kafka, Redis and ClickHouse, and all 22 migration scripts are idempotent.
Kafka serves as the buffer queue for usage events, ensuring the upstream gateway's write path is not blocked by jitter in the downstream analytics store; ClickHouse is a columnar OLAP database, good at aggregate scans over massive numbers of events, but not at high-frequency single-row updates and transactions.
The author advises: do not self-host ClickHouse for a project of this scale; for a two-person team it is just one more thing to look after at 2 a.m.
A Postgres conference talk compiled by ClickHouse put forward the view that "Postgres is not slow, your storage is slow," arguing that many complaints about Postgres performance are rooted in the configuration and selection of the underlying storage layer.
29 more timeline events
All Facts (20)
ClickHouse is a high-performance columnar analytical database that uses a columnar storage architecture where data is organized on disk by column rather than by row.
75%VerifiedLangfuse includes components such as a Web interface, PostgreSQL, Redis, ClickHouse, and a Langfuse Worker responsible for asynchronous evaluation.
65%UnverifiedNike's observability platform is based on Grafana and ClickHouse, processing about 200TB of data per day.
50%UnverifiedThe skeleton of frontend monitoring is divided into the collection layer, transport layer, storage layer, and alerting layer, among which the storage layer typically uses a columnar database such as ClickHouse.
50%UnverifiedDuckDB and cluster-deployment solutions like ClickHouse and Doris are complementary rather than substitutes.
50%UnverifiedFlagsmith Experiments allows users to connect their own ClickHouse or Databricks instances, while also offering a hosted repository option.
50%UnverifiedPostman introduced schema-aware read-only access to ClickHouse tables for structured data.
50%UnverifiedSystems such as ClickHouse, Amazon Redshift, Google BigQuery and Snowflake are designed specifically for OLAP scenarios.
50%UnverifiedThe author advises: do not self-host ClickHouse for a project of this scale; for a two-person team it is just one more thing to look after at 2 a.m.
50%UnverifiedKafka serves as the buffer queue for usage events, ensuring the upstream gateway's write path is not blocked by jitter in the downstream analytics store; ClickHouse is a columnar OLAP database, good at aggregate scans over massive numbers of events, but not at high-frequency single-row updates and transactions.
50%UnverifiedHe-API's usage events are written to ClickHouse via Kafka, while billing, model and provider metadata land in PostgreSQL; the system comprises 15 services running on systemd, all in Go except one Next.js admin console; the middleware includes Postgres, Kafka, Redis and ClickHouse, and all 22 migration scripts are idempotent.
50%UnverifiedA Postgres conference talk compiled by ClickHouse put forward the view that "Postgres is not slow, your storage is slow," arguing that many complaints about Postgres performance are rooted in the configuration and selection of the underlying storage layer.
50%UnverifiedClaude Dashboards directly connects to six types of data sources: BigQuery, Databricks, Snowflake, Redshift, ClickHouse, and Salesforce.
50%UnverifiedColumnar storage can deliver performance improvements of tens of times over traditional row-based databases for aggregation operations, because queries only read the involved columns rather than entire rows.
50%UnverifiedClickHouse was open-sourced by Russian company Yandex in 2016 and is designed specifically for OLAP (Online Analytical Processing) scenarios.
50%UnverifiedClickHouse supports vectorized execution and data compression, maintaining second-level response times when processing tens of billions of rows of data on a single machine.
50%UnverifiedCompanies such as ByteDance and Cloudflare use ClickHouse for internal log and user behavior analysis.
50%UnverifiedIn self-hosted Sentry, ClickHouse handles high-speed writing and querying of event data, while Kafka provides buffering and traffic shaping at the data ingestion layer.
50%UnverifiedThe primary method for self-hosting Sentry is the officially maintained self-hosted repository, which relies on Docker Compose to orchestrate a service stack comprising components such as PostgreSQL, Redis, Kafka, and ClickHouse.
50%UnverifiedMainstream data systems such as Elasticsearch, ClickHouse, and MongoDB have successively added vector index support.
50%