Alembic

Alembic Cheatsheet 01 — Setup and env.py

Cheatsheet: alembic init, env.py wiring for SQLAlchemy 2.0, async env.py, naming conventions.

Alembic Textbook Ch. 1 — Introduction and Setup

Alembic basics: setup with SQLAlchemy 2.0, env.py for sync/async, naming conventions, the migration directory.

Alembic Cheatsheet 02 — Commands

Cheatsheet: complete list of alembic CLI commands with flags and common scenarios.

Alembic Textbook Ch. 2 — Autogenerate: What It Sees, What It Misses

What Alembic autogenerate detects (tables, columns, indexes, constraints) and what it doesn’t (data migrations, complex changes, defaults), plus a review checklist.

Alembic Cheatsheet 03 — Autogenerate

Cheatsheet: autogenerate detection rules, common misses (renames, data, defaults), drift detection.

Alembic Textbook Ch. 3 — Writing Migrations Manually

Manual migrations: op API, ALTER patterns, batch ops for SQLite, data migrations, idempotent migrations.

Integration Cheatsheet 04 — Alembic + FastAPI Workflow

Cheatsheet: model change → autogenerate → review → upgrade → ship.

Alembic Cheatsheet 04 — op API Reference

Cheatsheet: op.create_table / drop / add_column / alter_column / indexes / constraints / FKs / raw SQL.

Alembic Textbook Ch. 4 — Branching, Merging, and Multiple Heads

Alembic branching: how multiple revisions create branches, merging strategies, and team workflows.

Alembic Cheatsheet 05 — Online (Zero-Downtime) Schema Changes

Cheatsheet: expand-contract pattern, CONCURRENTLY index, FK validation in two phases, batched backfill.