SQLAlchemy Cheatsheet 08 — Performance, N+1, Bulk Ops, Streaming
Cheatsheet: detect N+1, bulk insert/update, yield_per, load_only, defer, EXPLAIN, slow query logging.
Python
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.
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.
Python Cheatsheet 09 — Profiling (py-spy, cProfile, scalene)
Cheatsheet: when to use each profiler, common commands, reading output.
Integration Cheatsheet 09 — Deployment Stack (Docker + K8s + Migrations)
Cheatsheet: Dockerfile, K8s Deployment, migration Job, secrets, probes, graceful shutdown.
Alembic Cheatsheet 09 — Production Patterns
Cheatsheet: K8s Job vs app-startup, advisory-lock single runner, forward-only, recovery via stamp.
Pydantic Cheatsheet 09 — pydantic-settings
Cheatsheet: BaseSettings, env_file, env_prefix, nested, secrets_dir, CLI integration.
SQLAlchemy Cheatsheet 09 — Migrations Integration (Alembic)
Cheatsheet: Alembic setup with SQLAlchemy 2.0, env.py for sync/async, naming conventions, common ops.
Pydantic v2 Textbook Ch. 9 — Settings (pydantic-settings)
Pydantic-settings: typed env config, .env, secrets directory, sources, CLI integration.