SQLAlchemy Cheatsheet 03 — Session and Unit of Work
Cheatsheet: AsyncSession / Session, add/flush/commit/rollback, expire_on_commit, identity map, merge, scoped patterns.
Python
Alembic Textbook Ch. 3 — Writing Migrations Manually
Manual migrations: op API, ALTER patterns, batch ops for SQLite, data migrations, idempotent migrations.
Pydantic v2 Textbook Ch. 3 — Validators in Depth
All Pydantic v2 validation hooks: field_validator, model_validator, mode=before/after, custom validators via Annotated.
SQLAlchemy 2.0 Textbook Ch. 3 — Schema and the Type System
Schema in SQLAlchemy 2.0: typed mapped columns, Python types vs DB types, defaults, indexes, constraints, table_args.
Python Cheatsheet 04 — Decorators and Context Managers
Cheatsheet: function/class decorators, @wraps, async decorators, contextmanager, asynccontextmanager.
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.
Pydantic Cheatsheet 04 — Serialization
Cheatsheet: model_dump, exclude/include/exclude_none/exclude_unset, field_serializer, model_serializer.
SQLAlchemy Cheatsheet 04 — select(), where, joins, aggregates
Cheatsheet: select() / where / order_by / limit / offset / joins / aggregates / subqueries / CTEs / window funcs.
Alembic Textbook Ch. 4 — Branching, Merging, and Multiple Heads
Alembic branching: how multiple revisions create branches, merging strategies, and team workflows.