Textbook

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.

Postgres SQLAlchemy Textbook Ch. 1 — Dialects, asyncpg vs psycopg, and Postgres Setup

Postgres-focused SQLAlchemy: asyncpg vs psycopg v3, connect_args, server settings, dialect specifics, and choosing your driver.

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.

FastAPI Textbook Ch. 1 — Introduction, Architecture, and the ASGI Foundation

FastAPI architecture: ASGI, Starlette, Pydantic, dependency injection, and the design choices that make it tick.

Alembic Textbook Ch. 2 — Autogenerate: What It Sees, What It Misses

What Alembic autogenerate detects (tables, columns, indexes, constraints) and what it doesn’t (data migrations, complex changes, defaults), plus a review checklist.

Pydantic v2 Textbook Ch. 2 — Fields, Types, and Constraints

Field declaration, types (str, int, datetime, UUID, Decimal, EmailStr, HttpUrl), constraints, defaults, aliases.

Postgres SQLAlchemy Textbook Ch. 2 — JSONB, Arrays, Ranges, and Postgres-Specific Types

Postgres types in SQLAlchemy: JSONB queries, ARRAY operations, range types, citext, intervals, INET — with the dialect helpers.

SQLAlchemy 2.0 Textbook Ch. 2 — Engine, Pooling, and Connections

Engine and connection management: pool types, sizing, pre-ping, recycle, events, debugging.

FastAPI Textbook Ch. 2 — Routing, Path Operations, and the Request Anatomy

Path operations, parameter declaration (path / query / body / header / cookie / form / file), routers, prefixes, dependencies on routers, and request internals.