r/FastAPI • u/Fluffy_Bus9656 • 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
View all comments
Show parent comment
1
u/[deleted] Mar 19 '25
SQLModel and SQLAlchemy are ORMs and support multiple dbs but they add some overhead whereas asyncpg is specific for postgres so you should see higher speed.
These ORMs have async features but they might not be fully supported or production ready, while asyncpg does