A production-ready SQLAlchemy extension for FastAPI with built-in pagination, async support, SQLModel integration, and pytest fixtures.
Fastapi-SQLA is a SQLAlchemy extension for FastAPI that provides essential database utilities like pagination, session management, and testing support. It solves the problem of integrating SQLAlchemy with FastAPI in a production-ready manner, offering async compatibility and seamless SQLModel integration.
Backend developers building FastAPI applications with SQLAlchemy who need robust database utilities, pagination, and testing support.
Developers choose Fastapi-SQLA for its production-ready features, minimal configuration, and comprehensive support for modern Python async patterns and SQLAlchemy 2.0.
SQLAlchemy extension for FastAPI with support for pagination, asyncio, SQLModel and pytest, ready for production.
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.
Offers customizable pagination with async compatibility, simplifying endpoint creation in FastAPI, as shown with Paginate and Page response models in examples.
Provides full compatibility with SQLModel for type-safe database interactions without additional setup, demonstrated in the SQLModel support section.
Includes pre-configured Pytest fixtures with automatic transaction rollback and Alembic migration support, easing testing workflows for database operations.
Supports asyncio with asyncpg for PostgreSQL, enabling non-blocking queries in FastAPI, detailed in the async support configuration.
Async functionality is limited to PostgreSQL via asyncpg, with no native support for other async database drivers, restricting database flexibility.
Configuring multiple sessions requires specific environment variable naming and SQLAlchemy engine knowledge, adding initial complexity.
Pytest fixtures assume Alembic for migrations, which may not align with projects using other migration tools or custom strategies.