Integration Cheatsheet 01 — Full-Stack Project Skeleton
Cheatsheet: directory layout, pyproject, lifespan, db / settings / models / api wiring.
SQLAlchemy
SQLAlchemy + Postgres Cheatsheet 01 — asyncpg / psycopg Setup
Cheatsheet: driver selection, connection settings, PgBouncer-friendly config, RDS / Cloud SQL specifics.
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.
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.
SQLAlchemy + Postgres Cheatsheet 02 — JSONB Patterns
Cheatsheet: JSONB column, containment, path access, GIN index, jsonb_set, ON CONFLICT updates.
SQLAlchemy Cheatsheet 02 — Schema, Mapped Columns, and Types
Cheatsheet: DeclarativeBase, Mapped/mapped_column, type mappings, server_default, indexes, unique/check/FK, naming conventions.
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.