ClickHouse

ClickHouse® is an open-source column-oriented database management system that allows generating analytical data reports in real time.

Web site

Github repository

Tech tags:

• Data storage
• SQL query engine
• OLAP
• MPP architecture
• Column-oriented storage
• Realtime analytics

Related shared contents:

• Stream Processing vs. Real-Time OLAP: Flink, ClickHouse & Pinot Compared
  tech1
  2026-05-05

  The article explores the differences between stream processing and real-time OLAP systems, emphasizing their complementary roles in modern data architectures. It discusses when to use Apache Flink for continuous data transformations versus using OLAP databases like ClickHouse and Apache Pinot for interactive analytics. The author highlights the importance of a durable event streaming backbone, such as Apache Kafka, to connect these systems effectively. Key takeaways include understanding computation boundaries and avoiding common pitfalls in architecture design.

In productions with: