SQLAlchemy + Postgres Cheatsheet 10 — Upsert, RETURNING, and COPY
Cheatsheet: ON CONFLICT DO UPDATE / DO NOTHING, RETURNING, bulk insert via execute(insert(), list), asyncpg COPY.
PostgreSQL
Postgres SQLAlchemy Textbook Ch. 10 — Replication, Failover, and pgvector
Streaming replication, read replica routing, failover handling in SQLAlchemy, and using pgvector for embeddings.
SQLAlchemy + Postgres Cheatsheet 11 — Partitioning
Cheatsheet: declarative partitioning, partition creation, query pruning, pg_partman automation.
SQLAlchemy + Postgres Cheatsheet 12 — pgvector (Embeddings)
Cheatsheet: vector column, HNSW vs IVFFlat, cosine / L2 / inner-product distance, RAG hybrid filter.
SQLAlchemy + Postgres Cheatsheet 12 — Schema-Per-Tenant
Cheatsheet: per-tenant schemas, search_path, multi-schema Alembic env, onboarding.
SQLAlchemy + Postgres Cheatsheet 13 — Backups, PITR, Logical Backup
Cheatsheet: pg_dump options, pg_basebackup, pgBackRest, WAL archiving, RPO/RTO planning, restore tests.
SQLAlchemy + Postgres Cheatsheet 13 — DB-Per-Tenant
Cheatsheet: per-tenant engine cache, connection routing, multi-DB Alembic, onboarding.
SQLAlchemy + Postgres Cheatsheet 14 — pgvector for Embeddings
Cheatsheet: Vector column, cosine_distance / l2 / inner_product, HNSW index, hybrid filter + ANN.
SQLAlchemy + Postgres Cheatsheet 14 — Replication and Failover
Cheatsheet: streaming vs logical replication, Patroni, multi-host failover URLs, read replicas.
SQLAlchemy + Postgres Cheatsheet 15 — Maintenance (VACUUM, ANALYZE, REINDEX)
Cheatsheet: VACUUM variants, ANALYZE for stats, REINDEX for bloat, autovacuum tuning.