MergeTree is the engine behind almost every ClickHouse table. A close look at what ORDER BY actually does, how PRIMARY KEY differs from it, how the sparse index turns range scans into fast lookups, and where partitioning fits in.
ClickHouse MergeTree: ORDER BY, Partitioning, and the Sparse Index Read More »
ClickHouse uses SQL and looks familiar, but it is not “MySQL but faster.” What a MySQL developer needs to know before using it — columnar storage, no enforced primary key, append-only writes, batch inserts, and denormalized joins — with runnable Docker examples.
ClickHouse for MySQL Developers: What’s Different and Why Read More »
ClickHouse is an open-source columnar database built for analytics at massive scale: fast aggregation and filtering over very large datasets. ClickHouse may look like a relational database, but it’s engineered for a fundamentally different purpose than Postgres or MySQL, and treating it as a drop-in replacement is the most common way to get poor results.
This post covers what ClickHouse is, the workloads it is designed for, what it is used for, and when to stay with a traditional relational database instead.
What Is ClickHouse, and When Should You Use It? Read More »