Alembic Cheatsheet 07 — Multi-Database and Multi-Tenant
Cheatsheet: multidb template, schema-per-tenant env.py, parallel migrations.
Python
Pydantic Cheatsheet 07 — Strict vs Lax Mode
Cheatsheet: lax default, strict per model / field / call, bool-is-int gotcha, JSON vs dict input.
SQLAlchemy Cheatsheet 07 — Async Patterns and Streaming
Cheatsheet: AsyncEngine, AsyncSession, lazy loading caveats, streaming results, run_sync escape hatch.
Alembic Textbook Ch. 7 — CI Integration
Alembic CI patterns: drift detection, migration round-trip tests, dry-run, deploy gates, and pre-merge checks.
Pydantic v2 Textbook Ch. 7 — Strict Mode and Coercion
When Pydantic coerces vs raises: strict mode, per-field strict, lax/strict tradeoffs at API boundaries.
SQLAlchemy 2.0 Textbook Ch. 7 — Transactions and Concurrency
Transactions and concurrency: isolation levels, savepoints, FOR UPDATE locking, optimistic locking, retry patterns, and the cross-DB differences.
Python Cheatsheet 08 — Logging with structlog
Cheatsheet: structlog setup, JSON/console, contextvars, processors, trace correlation.
Integration Cheatsheet 08 — Testing the Full Stack
Cheatsheet: pytest setup, AsyncClient, real Postgres via testcontainers, factories, drift, migrations.
Alembic Cheatsheet 08 — CI Integration
Cheatsheet: GitHub Actions, drift test, up-down round-trip, dry-run SQL, deploy gates.
Pydantic Cheatsheet 08 — Aliases (Input/Output Field Names)
Cheatsheet: alias variants, populate_by_name, AliasChoices for multi-alias, AliasPath for nested input.