SQLAlchemy Cheatsheet 17 — Inheritance and Polymorphism
Cheatsheet: single-table inheritance, joined-table inheritance, concrete inheritance, polymorphic loading, with_polymorphic.
Python
Python Cheatsheet 18 — Exceptions and Error Handling
Cheatsheet: try/except/else/finally, raise from, ExceptionGroup, custom hierarchies.
Pydantic Cheatsheet 18 — Common Domain Types (IDs, Money, Phone, Email)
Cheatsheet: branded ID types, Decimal for money, phone validation, EmailStr, AwareDatetime.
SQLAlchemy Cheatsheet 18 — Hybrid Properties, Computed Columns, and Aggregates
Cheatsheet: when to use hybrid_property vs column_property vs Computed, with FastAPI integration.
Python Cheatsheet 19 — Testing Patterns Beyond pytest Basics
Cheatsheet: unittest.mock, freezegun, snapshot, hypothesis, factory_boy.
Pydantic Cheatsheet 19 — Testing Pydantic Models
Cheatsheet: parametrized tests, ValidationError assertions, factories, round-trip tests.
SQLAlchemy Cheatsheet 19 — Change Feeds, Outbox, and Logical Replication
Cheatsheet: outbox emit on commit, CDC via Debezium, logical replication, SKIP LOCKED worker pattern.
Python Cheatsheet 20 — Modern Project Setup (uv + ruff + mypy + pytest)
Cheatsheet: full pyproject.toml, pre-commit, GitHub Actions, layout, conventions.
Pydantic Cheatsheet 20 — Migration v1 → v2
Cheatsheet: method renames, Config → model_config, validator decorators, codemod (bump-pydantic).
SQLAlchemy Cheatsheet 20 — Recipes (Pagination, Filtering, Sorting, Bulk)
Cheatsheet: cursor pagination, filter from Pydantic, sort safelist, bulk upsert, COPY-fast loads.