SQLAlchemy Cheatsheet 05 — Relationships and Loading Strategies
Cheatsheet: relationship(), back_populates, secondary, cascade, joinedload / selectinload / subqueryload, lazy options.
SQLAlchemy
Postgres SQLAlchemy Textbook Ch. 5 — Locking, Advisory Locks, and SKIP LOCKED
Postgres locking patterns: SELECT FOR UPDATE, NOWAIT, SKIP LOCKED, advisory locks, application locks, deadlock retry.
SQLAlchemy 2.0 Textbook Ch. 5 — Querying with select()
Selecting rows in SQLAlchemy 2.0: select(), where, joins, group_by, aggregates, subqueries, CTEs, scalars vs rows.
Integration Cheatsheet 06 — Multi-Tenancy Across the Stack
Cheatsheet: tenant context, RLS policies, per-request session, isolation tests.
SQLAlchemy + Postgres Cheatsheet 06 — Full-Text Search
Cheatsheet: generated tsvector, websearch_to_tsquery, ts_rank, headline snippets, trigram hybrid.
SQLAlchemy Cheatsheet 06 — Transactions and Concurrency
Cheatsheet: session.begin, begin_nested, isolation levels, with_for_update, optimistic locking, deadlock retry.
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 2.0 Textbook Ch. 6 — Relationships and Loading Strategies
Relationship() in depth: configuration, loading strategies, N+1 prevention, association tables, polymorphic patterns.
SQLAlchemy + Postgres Cheatsheet 07 — Locking, SKIP LOCKED, Advisory Locks
Cheatsheet: row locking, NOWAIT, SKIP LOCKED queue, advisory locks (session and tx scoped).
SQLAlchemy Cheatsheet 07 — Async Patterns and Streaming
Cheatsheet: AsyncEngine, AsyncSession, lazy loading caveats, streaming results, run_sync escape hatch.