SQLAlchemy Setup
Configure SQLAlchemy 2.x with an async engine, declarative ORM models, and a session factory for use with FastAPI dependency injection.
CRUD Operations
Implement Create, Read, Update, and Delete operations with SQLAlchemy 2 async sessions, the select() API, and the repository pattern.
Migrations with Alembic
Set up Alembic for database schema migrations with SQLAlchemy 2, generate auto-migrations, and apply them in development and production.
Async Database Engines
Understand async SQLAlchemy engine configuration, connection pooling, async-safe query patterns, and common pitfalls with asyncpg.