Postgres-specific SQLAlchemy cheatsheets. Pair with the textbook .
SQLAlchemy + Postgres Cheatsheet 16 — VACUUM, Bloat, and Maintenance
Cheatsheet: autovacuum settings, manual vacuum, finding bloat, REINDEX CONCURRENTLY, table stats.
SQLAlchemy + Postgres Cheatsheets
Quick-reference cheatsheets for Postgres-specific SQLAlchemy — JSONB, arrays, indexes, FTS, locking, RLS.
SQLAlchemy + Postgres Cheatsheet 17 — pg_stat_statements and Slow Queries
Cheatsheet: enable pg_stat_statements, find top queries, auto_explain, slow-query log via SQLAlchemy events.
SQLAlchemy + Postgres Cheatsheet 18 — Backup, PITR, and Restore
Cheatsheet: pg_dump, pgBackRest, WAL archiving, PITR, restore testing.
SQLAlchemy + Postgres Cheatsheet 19 — Operational Patterns
Cheatsheet: PgBouncer config, app vs admin roles, statement_timeout, max_connections, scaling tactics.
SQLAlchemy + Postgres Cheatsheet 20 — Useful Postgres Extensions
Cheatsheet: pg_stat_statements, pg_trgm, citext, uuid-ossp, pgvector, pgcrypto, pg_partman, hypopg, pg_repack.