{{ message }}
Why not adopt a fully async stack? (asyncpg + async SQLAlchemy + async Alembic) #2271
Answered
by
mabuya02
MohamedMostafa259
asked this question in
Questions
Replies: 1 comment
0 replies
Answer selected by
MohamedMostafa259
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I think a fully async stack is valid, but I can see why it may not be the default for a starter template. FastAPI being async at the HTTP layer does not necessarily mean every layer must be async. Moving the template to async would affect more than the driver:
For high-concurrency apps, asyncpg + AsyncSession can make sense. But for a general template, the current sync SQLModel/SQLAlchemy setup is simpler, easier to debug, and easier for new users to understand.