SQLAlchemy + Postgres Cheatsheet 01 — asyncpg / psycopg Setup
Cheatsheet: driver selection, connection settings, PgBouncer-friendly config, RDS / Cloud SQL specifics.
PostgreSQL
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 + Postgres Cheatsheet 02 — JSONB Patterns
Cheatsheet: JSONB column, containment, path access, GIN index, jsonb_set, ON CONFLICT updates.
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 + Postgres Cheatsheet 03 — Arrays
Cheatsheet: ARRAY column, contains / overlaps / ANY, GIN index, append/remove operations.
Postgres SQLAlchemy Textbook Ch. 3 — Postgres Indexes in SQLAlchemy
Postgres index types via SQLAlchemy: B-tree, GIN, GiST, BRIN, HASH, partial, expression, INCLUDE indexes, and concurrent creation.
SQLAlchemy + Postgres Cheatsheet 04 — Ranges, INTERVAL, citext, INET
Cheatsheet: TSTZRANGE / NUMRANGE / DATERANGE, INTERVAL, citext, INET / CIDR, exclusion constraints.
Postgres SQLAlchemy Textbook Ch. 4 — Full-Text Search
Practical full-text search in Postgres via SQLAlchemy: tsvector, GIN, websearch_to_tsquery, ranking, and stemming.
Alembic Cheatsheet 05 — Online (Zero-Downtime) Schema Changes
Cheatsheet: expand-contract pattern, CONCURRENTLY index, FK validation in two phases, batched backfill.
SQLAlchemy + Postgres Cheatsheet 05 — Indexes (B-tree, GIN, GiST, BRIN, HASH)
Cheatsheet: pick the right Postgres index type for your access pattern.