SQLAlchemy — Deep Topical Notes

1 min read index source

SQLAlchemy — Deep Topical Notes

Focused interview-prep notes on SQLAlchemy. The parent ../06_sqlalchemy.md is the overview; this folder is the deep dive.

Files

# Topic
01 Core vs ORM
02 Engine, Connection, Session
03 Declarative models
04 Relationships
05 Query and 2.0 select style
06 Loading strategies and N+1
07 Unit of Work and Identity Map
08 Session lifecycle
09 Transactions and savepoints
10 Connection pooling
11 Async SQLAlchemy
12 Bulk operations and performance
13 Testing patterns
14 Common pitfalls