Python Forum
SQLModel vs SQLAlchemy - Printable Version

+- Python Forum (https://python-forum.io)
+-- Forum: Python Coding (https://python-forum.io/forum-7.html)
+--- Forum: General Coding Help (https://python-forum.io/forum-8.html)
+--- Thread: SQLModel vs SQLAlchemy (/thread-43552.html)



SQLModel vs SQLAlchemy - Dummkopf - Nov-18-2024

Hey everyone, I was wondering whether the current releases of SQLModel is appropriate for production? Couldn’t find a recent post about this I’m trying to set up a web app with fastapi backend and react frontend. Was deciding whether to pick SQLAlchemy or not


RE: SQLModel vs SQLAlchemy - Larz60+ - Nov-18-2024

SQLAlchemy was last updated last month, so lI'd expact it's good to go.

I don't see any advantage of using SQLmodel, as it's just as easy to build a database model from scratch.

There is a tutorial (which I wrote) here that shows how to build a model from scratch. And another one that shows how to build one programatically here.


RE: SQLModel vs SQLAlchemy - snippsat - Nov-18-2024

SQLModel is build upon SQLAlchemy and Pydantic.
For FastApi is SQLModel(SQL (Relational) Databases) the default choice.
Quote:As SQLModel is based on SQLAlchemy, you can easily use any database supported by SQLAlchemy (which makes them also supported by SQLModel), like:

PostgreSQL
MySQL
SQLite
Oracle
Microsoft SQL Server, etc.
So i would have no worries to use SQLModel in production as i the default choice for FastAPI(It's now a mature framework).