Alembic Textbook Ch. 7 — CI Integration
Alembic CI patterns: drift detection, migration round-trip tests, dry-run, deploy gates, and pre-merge checks.
Textbook
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.
Postgres SQLAlchemy Textbook Ch. 7 — Partitioning Strategies
Postgres declarative partitioning via SQLAlchemy: range/list/hash partitions, pg_partman automation, indexes per partition.
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.
FastAPI Textbook Ch. 7 — Async, Concurrency, and the Threadpool
Concurrency in FastAPI: async vs sync handlers, the threadpool, AnyIO, blocking traps, structured concurrency, and how to scale.
Alembic Textbook Ch. 8 — Production Patterns and Recovery
Production Alembic: deploy strategies, recovery from broken migrations, stamp, manual fixes, and the operational checklist.
Pydantic v2 Textbook Ch. 8 — JSON Schema Generation
JSON Schema from Pydantic: model_json_schema, OpenAPI integration, custom schemas, examples.
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 2.0 Textbook Ch. 8 — Async SQLAlchemy in Depth
Async patterns in SQLAlchemy 2.0: AsyncSession, expire_on_commit, async streaming, lazy loading caveats, AsyncSession scopes.
FastAPI Textbook Ch. 8 — WebSockets, SSE, and Streaming Responses
Real-time FastAPI: WebSockets, broadcast / pub-sub, SSE for one-way streams, StreamingResponse, NDJSON, and disconnect handling.