Tool
ClickHouse is an open-source, column-oriented database management system for online analytical processing (OLAP) and real-time analytics. It stores data by column and uses optimized compression and vectorized query execution to process analytical SQL queries while using available CPU resources efficiently. It supports large-scale workloads such as real-time analytics, observability, data warehousing, and machine learning or generative AI applications, including vector search and aggregations.
ClickHouse can be self-managed on a machine or deployed through ClickHouse Cloud on AWS, Google Cloud, and Microsoft Azure. ClickHouse Local runs queries on local files such as CSV, TSV, and Parquet without a server. The project provides installers for macOS, Linux, FreeBSD, and Windows, as well as Docker and playground options; the self-managed database is open source.
5 uses taken from transcripts — each links to the moment in the video.
An open-source database management system for real-time analytics. It is used to store and query vast volumes of data with very fast query execution and high resource efficiency.
Database the speaker self-hosts on R2 to mirror analytics data more cheaply
Data store underlying Langfuse's data plane after Postgres could not scale to billions of events per day
Primary analytics database used by AI observability tools; lacks managed cross-region failover
Database where the CLI proxy dumps all requests and responses so usage can be queried
5 in the library.