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 »
PostgreSQL 18 introduces a new version‑specific data directory that breaks old Docker volumes. This guide shows how to upgrade from PostgreSQL 17 to 18 using a clean dump‑and‑restore workflow.
PostgreSQL 18 Docker Upgrade: Dump and Restore Method Read More »
What are Web Vitals? Web Vitals is an initiative by Google to provide unified guidance for quality signals that are essential to delivering a great user experience on the web. These consists of some Core Web Vitals (LCP, FID and CLS) and a few others (TTFB and FCP). What are Core Web Vitals? For the
Web Vitals Metrics – What you should know Read More »