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 »
There are a few different ways to track Web Vitals, however the easiest way is using the web-vitals JavaScript library. In this post we will load the web-vitals directly from CDN and use that to track the Core Web Vitals (LCP, FID, CLS) and other Web Vitals (FCP, TTFB) metrics. Track Web Vitals in
Tracking Web Vitals in Google Analytics Read More »