Long-form textbooks. Each is a chaptered series that builds on previous chapters — open the index for a table of contents and read in order.
Need a quick reference instead? See the cheatsheets .
A deep textbook on Alembic — migrations, autogeneration, branching, online schema changes, multi-DB, CI integration, and recovery patterns.
A deep, end-to-end textbook on FastAPI covering routing, DI, validation, async, security, deployment, observability, and integrations with SQLAlchemy / Pydantic / Alembic.
Postgres-specific SQLAlchemy 2.0 — array, JSONB, ranges, full-text search, listen/notify, dialect features, asyncpg/psycopg, partitioning, replication, advisory locks.
A deep textbook on Pydantic v2 — validation, serialization, models, validators, computed fields, settings, performance, JSON Schema, FastAPI integration.
A deep, end-to-end textbook on SQLAlchemy 2.0 — Core, ORM, async, sessions, units of work, queries, relationships, performance — with notes on Postgres / MySQL / SQLite differences.