PostgreSQL

SQLAlchemy + Postgres Cheatsheet 15 — Replication, Read Replicas, and Failover

Cheatsheet: writer/reader engines, target_session_attrs, read-after-write, replica lag awareness.

SQLAlchemy + Postgres Cheatsheet 16 — Postgres Extensions

Cheatsheet: the extensions worth knowing — pg_trgm, citext, pg_partman, pg_cron, pgvector, PostGIS, pgaudit.

SQLAlchemy + Postgres Cheatsheet 16 — VACUUM, Bloat, and Maintenance

Cheatsheet: autovacuum settings, manual vacuum, finding bloat, REINDEX CONCURRENTLY, table stats.

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.

Postgres as Everything in 2026 — Queue, Cache, Search, Vector, Analytics

Practical ‘just use Postgres’ patterns: queues with SKIP LOCKED, caching with UNLOGGED tables, FTS, pgvector, JSONB, time-series, and when to actually graduate.

Postgres as a Queue in 2026 — Boring, Reliable, Underrated

Practical Postgres-backed queues: SKIP LOCKED for concurrency, LISTEN/NOTIFY for low-latency wake-up, retries, dead-letter, and when to graduate to Kafka.

Postgres Locking in 2026 — Row Locks, Advisory Locks, and Avoiding Deadlocks

Practical Postgres locking: SELECT FOR UPDATE, NOWAIT, SKIP LOCKED, advisory locks, isolation levels, and how to debug locking problems.