FastAPI SQLAlchemy

The DBSessionMiddleware automatically handles database session creation and cleanup within FastAPI request contexts, as shown in route examples, eliminating repetitive session boilerplate.

Provides a context manager (with db():) for database access outside requests, enabling easy integration with scheduled jobs, demonstrated in the APScheduler example for tasks like user counting.

Includes an extensible ModelBase with built-in methods like save, update, and query helpers, streamlining common CRUD operations without extra code, as shown in the custom BaseModel example.

Allows configuration of multiple database connections simultaneously, facilitating complex applications with separate data sources, referenced in the multi-db example directory.