Postgres SQLAlchemy Textbook Ch. 7 — Partitioning Strategies
Postgres declarative partitioning via SQLAlchemy: range/list/hash partitions, pg_partman automation, indexes per partition.
SQLAlchemy
SQLAlchemy 2.0 Textbook Ch. 7 — Transactions and Concurrency
Transactions and concurrency: isolation levels, savepoints, FOR UPDATE locking, optimistic locking, retry patterns, and the cross-DB differences.
SQLAlchemy + Postgres Cheatsheet 08 — LISTEN / NOTIFY
Cheatsheet: NOTIFY from a transaction, listen via asyncpg, outbox + LISTEN wake-up pattern.
SQLAlchemy Cheatsheet 08 — Performance, N+1, Bulk Ops, Streaming
Cheatsheet: detect N+1, bulk insert/update, yield_per, load_only, defer, EXPLAIN, slow query logging.
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 2.0 Textbook Ch. 8 — Async SQLAlchemy in Depth
Async patterns in SQLAlchemy 2.0: AsyncSession, expire_on_commit, async streaming, lazy loading caveats, AsyncSession scopes.
SQLAlchemy + Postgres Cheatsheet 09 — Row-Level Security for Multi-Tenancy
Cheatsheet: enable RLS, write policies, set tenant per request, application role without BYPASSRLS.
SQLAlchemy Cheatsheet 09 — Migrations Integration (Alembic)
Cheatsheet: Alembic setup with SQLAlchemy 2.0, env.py for sync/async, naming conventions, common ops.
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 2.0 Textbook Ch. 9 — Performance: N+1, Bulk Ops, Streaming
Practical SQLAlchemy performance: avoiding N+1, bulk_insert_mappings, server-side cursors, EXPLAIN ANALYZE patterns.