Postgres-specific SQLAlchemy cheatsheets. Pair with the textbook .
SQLAlchemy + Postgres Cheatsheet 01 — asyncpg / psycopg Setup
Cheatsheet: driver selection, connection settings, PgBouncer-friendly config, RDS / Cloud SQL specifics.
SQLAlchemy + Postgres Cheatsheets
Quick-reference cheatsheets for Postgres-specific SQLAlchemy — JSONB, arrays, indexes, FTS, locking, RLS.
SQLAlchemy + Postgres Cheatsheet 02 — JSONB Patterns
Cheatsheet: JSONB column, containment, path access, GIN index, jsonb_set, ON CONFLICT updates.
SQLAlchemy + Postgres Cheatsheet 03 — Arrays
Cheatsheet: ARRAY column, contains / overlaps / ANY, GIN index, append/remove operations.
SQLAlchemy + Postgres Cheatsheet 04 — Ranges, INTERVAL, citext, INET
Cheatsheet: TSTZRANGE / NUMRANGE / DATERANGE, INTERVAL, citext, INET / CIDR, exclusion constraints.
SQLAlchemy + Postgres Cheatsheet 05 — Indexes (B-tree, GIN, GiST, BRIN, HASH)
Cheatsheet: pick the right Postgres index type for your access pattern.
SQLAlchemy + Postgres Cheatsheet 06 — Full-Text Search
Cheatsheet: generated tsvector, websearch_to_tsquery, ts_rank, headline snippets, trigram hybrid.
SQLAlchemy + Postgres Cheatsheet 07 — Locking, SKIP LOCKED, Advisory Locks
Cheatsheet: row locking, NOWAIT, SKIP LOCKED queue, advisory locks (session and tx scoped).
SQLAlchemy + Postgres Cheatsheet 08 — LISTEN / NOTIFY
Cheatsheet: NOTIFY from a transaction, listen via asyncpg, outbox + LISTEN wake-up pattern.
SQLAlchemy + Postgres Cheatsheet 09 — Row-Level Security for Multi-Tenancy
Cheatsheet: enable RLS, write policies, set tenant per request, application role without BYPASSRLS.
SQLAlchemy + Postgres Cheatsheet 10 — Upsert, RETURNING, and COPY
Cheatsheet: ON CONFLICT DO UPDATE / DO NOTHING, RETURNING, bulk insert via execute(insert(), list), asyncpg COPY.