SQLAlchemy Cheatsheet 11 — Events and Hooks
Cheatsheet: engine events (connect/checkout/before_cursor_execute), session events (before_commit), mapper hooks (before_insert/update/delete), attribute events.
Python
SQLAlchemy 2.0 Textbook Ch. 11 — Testing
Testing SQLAlchemy: real DBs via testcontainers, per-test transactions, factory_boy, async fixtures, and CI patterns.
Python Cheatsheet 12 — Standard Library Highlights
Cheatsheet: collections, json, os, sys, subprocess, secrets, hashlib, hmac.
Pydantic Cheatsheet 12 — Error Handling
Cheatsheet: ValidationError.errors(), loc / type / msg, custom error envelopes, FastAPI 400/422.
SQLAlchemy Cheatsheet 12 — Repository and Unit-of-Work Pattern
Cheatsheet: repository classes, unit-of-work, generic base repo, service-layer separation.
SQLAlchemy 2.0 Textbook Ch. 12 — Production Patterns
Production SQLAlchemy: pool sizing with PgBouncer, read replica routing, OTEL instrumentation, multi-tenancy with RLS, and graceful failure modes.
Python Cheatsheet 13 — httpx (Sync + Async HTTP Client)
Cheatsheet: httpx Client / AsyncClient, requests, timeouts, retries, streaming.
Pydantic Cheatsheet 13 — ORM Mode (from_attributes)
Cheatsheet: from_attributes=True, computed fields from ORM, eager-loading relations, exclude sensitive.
SQLAlchemy Cheatsheet 13 — Soft Delete, Audit, and Timestamps
Cheatsheet: SoftDeleteMixin, auto-timestamps via events, audit log table, with_loader_criteria for transparent filtering.
Python Cheatsheet 14 — CLI Tools (Typer / Click / argparse)
Cheatsheet: Typer for modern CLIs, Click for power users, argparse for stdlib.