🗄️ClickHouse
Also known as ClickHouse Cloud, ClickHouse DB
A free, open-source database that stores data in columns. It is built for quick sums.
Think of it like
It is like a sorting machine at a post office. Huge piles go in, and the counts come out fast.
Example
A game studio sends every player click to ClickHouse. Its live dashboard shows how many people are playing each level right now.
Why it matters
It answers big questions fast enough for live charts. The open-source version costs nothing to run.
Definition
Example code
sql
CREATE TABLE events
(
event_date Date,
user_id UInt64,
action String
)
ENGINE = MergeTree
ORDER BY (event_date, user_id);Common mistake
Key takeaways
- 1Columns. Data is stored one column at a time.
- 2Batches in. Add rows in large groups.
- 3Open source. Run it yourself, or rent the cloud one.