sqlalchemy-async-session-factory¶

Factory functions for async SQLAlchemy engine and session management with connection pooling.

Installation¶

pip install sqlalchemy-async-session-factory

Public API¶

Function	Purpose
`create_async_engine_with_pool(database_url, ...)`	Create async engine with pool config
`create_async_session_maker(engine, ...)`	Create `async_sessionmaker`
`create_session_dependency(session_maker)`	FastAPI `Depends()` factory
`suppress_pool_warnings()`	Suppress pool warnings during shutdown
`setup_pool_event_handlers(engine)`	Pool event handlers (monitoring)

Usage¶

from sqlalchemy_async_session_factory import (
    create_async_engine_with_pool,
    create_async_session_maker,
    create_session_dependency,
)

engine = create_async_engine_with_pool("postgresql+asyncpg://...")
session_maker = create_async_session_maker(engine)
get_session = create_session_dependency(session_maker)

# FastAPI dependency injection
@app.get("/users")
async def list_users(session=Depends(get_session)):
    ...