Alembic Textbook Ch. 5 — Online Schema Changes (Zero-Downtime Patterns)
Zero-downtime migrations: expand-contract, batched backfills, CONCURRENTLY, NOT VALID FK, and pg_repack.
PostgreSQL
Postgres SQLAlchemy Textbook Ch. 5 — Locking, Advisory Locks, and SKIP LOCKED
Postgres locking patterns: SELECT FOR UPDATE, NOWAIT, SKIP LOCKED, advisory locks, application locks, deadlock retry.
SQLAlchemy + Postgres Cheatsheet 06 — Full-Text Search
Cheatsheet: generated tsvector, websearch_to_tsquery, ts_rank, headline snippets, trigram hybrid.
Postgres SQLAlchemy Textbook Ch. 6 — LISTEN / NOTIFY for Pub/Sub
LISTEN/NOTIFY patterns: real-time event delivery, queue wake-up, payload limits, and combining with the outbox pattern.
SQLAlchemy + Postgres Cheatsheet 07 — Locking, SKIP LOCKED, Advisory Locks
Cheatsheet: row locking, NOWAIT, SKIP LOCKED queue, advisory locks (session and tx scoped).
Postgres SQLAlchemy Textbook Ch. 7 — Partitioning Strategies
Postgres declarative partitioning via SQLAlchemy: range/list/hash partitions, pg_partman automation, indexes per partition.
SQLAlchemy + Postgres Cheatsheet 08 — LISTEN / NOTIFY
Cheatsheet: NOTIFY from a transaction, listen via asyncpg, outbox + LISTEN wake-up pattern.
Postgres SQLAlchemy Textbook Ch. 8 — Row-Level Security and Multi-Tenancy
Postgres RLS for multi-tenant SQLAlchemy: defining policies, setting tenant context per request, and integration with FastAPI.
SQLAlchemy + Postgres Cheatsheet 09 — Row-Level Security for Multi-Tenancy
Cheatsheet: enable RLS, write policies, set tenant per request, application role without BYPASSRLS.
Postgres SQLAlchemy Textbook Ch. 9 — Upsert, Bulk Insert, and COPY
Postgres-specific bulk operations: ON CONFLICT, RETURNING, bulk insert via execute, asyncpg COPY for huge data.