Alembic Textbook Ch. 5 — Online Schema Changes (Zero-Downtime Patterns)
Zero-downtime migrations: expand-contract, batched backfills, CONCURRENTLY, NOT VALID FK, and pg_repack.
Alembic
Alembic Cheatsheet 06 — Branching and Merging
Cheatsheet: when branches form, alembic merge, single-head CI gate, recovery.
Alembic Textbook Ch. 6 — Multi-Database and Multi-Tenant Migrations
Multi-DB migrations via Alembic: -t multidb template, schema-per-tenant strategies, parallelism.
Alembic Cheatsheet 07 — Multi-Database and Multi-Tenant
Cheatsheet: multidb template, schema-per-tenant env.py, parallel migrations.
Alembic Textbook Ch. 7 — CI Integration
Alembic CI patterns: drift detection, migration round-trip tests, dry-run, deploy gates, and pre-merge checks.
Alembic Cheatsheet 08 — CI Integration
Cheatsheet: GitHub Actions, drift test, up-down round-trip, dry-run SQL, deploy gates.
Alembic Textbook Ch. 8 — Production Patterns and Recovery
Production Alembic: deploy strategies, recovery from broken migrations, stamp, manual fixes, and the operational checklist.
Alembic Cheatsheet 09 — Production Patterns
Cheatsheet: K8s Job vs app-startup, advisory-lock single runner, forward-only, recovery via stamp.
SQLAlchemy Cheatsheet 09 — Migrations Integration (Alembic)
Cheatsheet: Alembic setup with SQLAlchemy 2.0, env.py for sync/async, naming conventions, common ops.
Alembic Cheatsheet 10 — Common Migration Recipes
Cheatsheet: copy-paste migrations for common changes — add NOT NULL column, rename, FK, ENUM, JSONB, view, trigger.