Posts tagged “mysql”

Tiny explainers grouped by topic. Spend less time Googling, more time building.

Zero‑Downtime Migrations — expand/contract without breaking prod

Change schemas safely with backward‑compatible steps, dual writes, background backfills, and rolling deploys. Postgres‑flavored, but patterns apply to MySQL and friends.

September 14th, 2025

devdatabasesmigrations

Database Indexing 101 — faster queries, fewer surprises

A practical mental model for indexes, with copy‑paste patterns for B‑tree, composite order, covering, partial, and expression indexes—plus when **not** to index.

September 12th, 2025

devdatabasessql