SQLModel vs SQLAlchemy

[Dummkopf]

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

[Larz60+]

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.

[snippsat]

SQLModel is build upon SQLAlchemy and Pydantic.
For FastApi is SQLModel(SQL (Relational) Databases) the default choice.

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).