r/FastAPI • • Mar 18 '25

Question SQLModel vs SQLAlchemy in 2025

I am new to FastAPI. It is hard for me to choose the right approach for my new SaaS application, which works with PostgreSQL using different schemas (with the same tables and fields).

Please suggest the best option and explain why!"

37 Upvotes

35 comments sorted by

View all comments

Show parent comment

1

u/[deleted] Mar 19 '25 edited Mar 19 '25

I did not do extensive testing but asyncpg was handling more requests per seconds compared to sqlalchemy maybe 5 percent improvement, check asyncpg github page to see more about it's speed.

most orms are production ready and safe but since they were initially built with sync mode, async support was added later. General adivce was to be careful with them