Integration Cheatsheet 03 — Pydantic ↔ SQLAlchemy Mapping
Cheatsheet: schema vs model separation, partial updates, ORM-to-API conversion, nested relations.
SQLAlchemy
SQLAlchemy + Postgres Cheatsheet 03 — Arrays
Cheatsheet: ARRAY column, contains / overlaps / ANY, GIN index, append/remove operations.
SQLAlchemy Cheatsheet 03 — Session and Unit of Work
Cheatsheet: AsyncSession / Session, add/flush/commit/rollback, expire_on_commit, identity map, merge, scoped patterns.
Postgres SQLAlchemy Textbook Ch. 3 — Postgres Indexes in SQLAlchemy
Postgres index types via SQLAlchemy: B-tree, GIN, GiST, BRIN, HASH, partial, expression, INCLUDE indexes, and concurrent creation.
SQLAlchemy 2.0 Textbook Ch. 3 — Schema and the Type System
Schema in SQLAlchemy 2.0: typed mapped columns, Python types vs DB types, defaults, indexes, constraints, table_args.
SQLAlchemy + Postgres Cheatsheet 04 — Ranges, INTERVAL, citext, INET
Cheatsheet: TSTZRANGE / NUMRANGE / DATERANGE, INTERVAL, citext, INET / CIDR, exclusion constraints.
SQLAlchemy Cheatsheet 04 — select(), where, joins, aggregates
Cheatsheet: select() / where / order_by / limit / offset / joins / aggregates / subqueries / CTEs / window funcs.
Postgres SQLAlchemy Textbook Ch. 4 — Full-Text Search
Practical full-text search in Postgres via SQLAlchemy: tsvector, GIN, websearch_to_tsquery, ranking, and stemming.
SQLAlchemy 2.0 Textbook Ch. 4 — The Session and the Unit of Work
Session deep dive: lifecycle, identity map, flush, commit, expire_on_commit, refresh, the unit of work.
SQLAlchemy + Postgres Cheatsheet 05 — Indexes (B-tree, GIN, GiST, BRIN, HASH)
Cheatsheet: pick the right Postgres index type for your access pattern.