SQLAlchemy 2.0 Textbook Ch. 9 — Performance: N+1, Bulk Ops, Streaming
Practical SQLAlchemy performance: avoiding N+1, bulk_insert_mappings, server-side cursors, EXPLAIN ANALYZE patterns.
Python
Python Cheatsheet 10 — pathlib (Modern File Paths)
Cheatsheet: Path basics, joining, globbing, reading, writing, traversing.
Integration Cheatsheet 10 — Observability Stack
Cheatsheet: structlog with trace IDs, OTEL auto-instrumentation, Prometheus, slow-query log.
Alembic Cheatsheet 10 — Common Migration Recipes
Cheatsheet: copy-paste migrations for common changes — add NOT NULL column, rename, FK, ENUM, JSONB, view, trigger.
Pydantic Cheatsheet 10 — JSON Schema and OpenAPI
Cheatsheet: model_json_schema modes, json_schema_extra, custom JSON Schema, LLM tools.
SQLAlchemy Cheatsheet 10 — Production Patterns
Cheatsheet: PgBouncer, read replica routing, OTEL instrumentation, multi-tenancy (RLS), DR / failover.
Pydantic v2 Textbook Ch. 10 — Performance, FastAPI Integration, and Alternatives
Pydantic v2 perf tips, hot path optimization, FastAPI patterns, and when to consider msgspec / attrs.
SQLAlchemy 2.0 Textbook Ch. 10 — Migrations and Schema Evolution
Schema migrations: Alembic integration, autogenerate, manual edits, branching, online schema changes, deploy patterns.
Python Cheatsheet 11 — datetime, zoneinfo, and Time
Cheatsheet: datetime, zoneinfo, ISO 8601, timezone conversion, common pitfalls.
Pydantic Cheatsheet 11 — Performance
Cheatsheet: speed pitfalls and fixes; when to reach for msgspec.