Tool

ClickHouse

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.

Visit site Mentioned in 5 videos ↓

Overview

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.

What ClickHouse is used for

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

Videos mentioning ClickHouse

5 in the library.