Python Cheatsheet 01 — asyncio Essentials
Cheatsheet: async/await basics, asyncio.run, gather vs TaskGroup, timeouts, cancellation.
Python
Integration Cheatsheet 01 — Full-Stack Project Skeleton
Cheatsheet: directory layout, pyproject, lifespan, db / settings / models / api wiring.
Alembic Cheatsheet 01 — Setup and env.py
Cheatsheet: alembic init, env.py wiring for SQLAlchemy 2.0, async env.py, naming conventions.
Pydantic Cheatsheet 01 — BaseModel Basics
Cheatsheet: BaseModel definition, model_validate, model_dump, model_config.
SQLAlchemy Cheatsheet 01 — Engine, Pool, and Connection
Cheatsheet: create_engine / create_async_engine, pool params, pre-ping, recycle, events, lifespan integration.
Alembic Textbook Ch. 1 — Introduction and Setup
Alembic basics: setup with SQLAlchemy 2.0, env.py for sync/async, naming conventions, the migration directory.
Pydantic v2 Textbook Ch. 1 — Introduction and the v2 Mental Model
Pydantic v2 mental model: validation (input → model), serialization (model → output), the Rust core, and what changed from v1.
SQLAlchemy 2.0 Textbook Ch. 1 — Introduction, Core vs ORM, and the 2.0 Mental Model
SQLAlchemy 2.0 introduction: Core vs ORM, the unified API, engine + connection, basic select / insert / update / delete.
Python Cheatsheet 02 — Type Hints (Modern)
Cheatsheet: X | None syntax, generics, Protocol, TypedDict, ParamSpec, type guards.
Integration Cheatsheet 02 — Full Request Lifecycle
Cheatsheet: trace a request from socket to response through all four libraries.