Cursor-Based Pagination Done Right: Keyset Queries, Opaque Cursors, and the Pitfalls That Bite
Every API that returns a list eventually has to answer the same question: how do you hand out a million
Tag: Databases
Reading EXPLAIN ANALYZE: Why Postgres Ignores Your Index
Every slow query investigation eventually reaches the same moment: you run EXPLAIN ANALYZE, and the plan makes no sense. Postgres
Continue readingReading EXPLAIN ANALYZE: Why Postgres Ignores Your Index
Zero-Downtime Database Migrations: Expand-Contract, Backfills, and Locks
Every schema migration tool will happily tell you how to change a table. Almost none of them will tell you
Continue readingZero-Downtime Database Migrations: Expand-Contract, Backfills, and Locks
Database Connection Pooling: PgBouncer, Pool Sizing, and the Math Behind Both
Every PostgreSQL connection is a process on the server. Not a thread, not an entry in a table — a
Continue readingDatabase Connection Pooling: PgBouncer, Pool Sizing, and the Math Behind Both
Optane vs. Modern SSDs: Why the Fastest Drive Ever Made Is One Nobody Can Buy
In 2022, Intel quietly buried the fastest storage medium anyone had ever shipped. Optane, built on 3D XPoint memory, was
Continue readingOptane vs. Modern SSDs: Why the Fastest Drive Ever Made Is One Nobody Can Buy
Row Stores vs Column Stores: Why Analytics and OLTP Are Opposites
Every data engineer eventually has the same moment: the dashboard query that was instant on a million rows takes ninety
Continue readingRow Stores vs Column Stores: Why Analytics and OLTP Are Opposites
PostgreSQL vs MySQL in 2026: A Practitioner’s Comparison
PostgreSQL versus MySQL is one of the oldest rivalries in software, and like most old rivalries it is mostly narrated
Continue readingPostgreSQL vs MySQL in 2026: A Practitioner’s Comparison
SQLite in Production: The Database You Already Ship
Most applications don’t need a database server. They need durable, queryable state — and somewhere along the way the industry
Continue readingSQLite in Production: The Database You Already Ship
SQL Window Functions in PostgreSQL: Running Totals, Rankings, and the End of Self-Joins
Every reporting query has a moment where GROUP BY stops being enough. You need the aggregate and the row it
Apache Iceberg vs Delta Lake vs Hudi: Choosing Your Lakehouse Table Format
The data lakehouse has gone from contested idea to default architecture in just a few years, and the table format
Continue readingApache Iceberg vs Delta Lake vs Hudi: Choosing Your Lakehouse Table Format