SQLAlchemy + Postgres Cheatsheet 06 — Full-Text Search
Cheatsheet: generated tsvector, websearch_to_tsquery, ts_rank, headline snippets, trigram hybrid.
Postgresql
Postgres SQLAlchemy Textbook Ch. 6 — LISTEN / NOTIFY for Pub/Sub
LISTEN/NOTIFY patterns: real-time event delivery, queue wake-up, payload limits, and combining with the outbox pattern.
SQLAlchemy + Postgres Cheatsheet 07 — Locking, SKIP LOCKED, Advisory Locks
Cheatsheet: row locking, NOWAIT, SKIP LOCKED queue, advisory locks (session and tx scoped).
Postgres SQLAlchemy Textbook Ch. 7 — Partitioning Strategies
Postgres declarative partitioning via SQLAlchemy: range/list/hash partitions, pg_partman automation, indexes per partition.
SQLAlchemy + Postgres Cheatsheet 08 — LISTEN / NOTIFY
Cheatsheet: NOTIFY from a transaction, listen via asyncpg, outbox + LISTEN wake-up pattern.
Postgres SQLAlchemy Textbook Ch. 8 — Row-Level Security and Multi-Tenancy
Postgres RLS for multi-tenant SQLAlchemy: defining policies, setting tenant context per request, and integration with FastAPI.
SQLAlchemy + Postgres Cheatsheet 09 — Row-Level Security for Multi-Tenancy
Cheatsheet: enable RLS, write policies, set tenant per request, application role without BYPASSRLS.
Postgres SQLAlchemy Textbook Ch. 9 — Upsert, Bulk Insert, and COPY
Postgres-specific bulk operations: ON CONFLICT, RETURNING, bulk insert via execute, asyncpg COPY for huge data.
SQLAlchemy + Postgres Cheatsheet 10 — Upsert, RETURNING, and COPY
Cheatsheet: ON CONFLICT DO UPDATE / DO NOTHING, RETURNING, bulk insert via execute(insert(), list), asyncpg COPY.
Postgres SQLAlchemy Textbook Ch. 10 — Replication, Failover, and pgvector
Streaming replication, read replica routing, failover handling in SQLAlchemy, and using pgvector for embeddings.