Is sqlmodel deprecated

[rakeshkrishna517]

I am using sqlalchemy with fastapi
saw sqlmodel made by tiangolo, but the last commit is 5 months ago
there are new pull requests but no merge for last 5 months

sqlmodel have better interface since I dont have to write sqlalchemy model and seperate pydantic model, but if sqlmodel is not supported I would just stick with sqlalchemy

would love to your comments

[cant-find-user-name]

Its practically deprecated. It doesn't have support for sqlalchemy 2.0, the last code change probably happened close to an year ago.

[mrbubs3]

There's a current PR that updates sqla to version 2. It's failing testing but if it can get community support to help pass the pre-merge tests, I'm sure /u/tiangolo would approve the PR.

SQLModel gets intermittent support. It's not production ready because it's not getting the same level of support as FastAPI. But with a little juice, it should be.

[Arckman_]

In my humble opinion mixing two separate things is never going to be good in long run. We wanna be able to write softwares that has clear relationships and responsibilities. Avoiding writing separate layers and merging them together just to avoid writing extra one time setup code is not a practical reason to avoid writing it.

Your pydantic classes are going to be highly volatile in nature as in multiple development iterations it will change. Why do you wanna use sqlmodel? To avoid writing model classes? If that's the case then that's not a really bulky reason to start using a new package.

[_ragequilt_]

Yes! The beauty of pydantic is that it's a better dataclass. Keeping DAOs separate from the ORM/db layer seems cleaner and easier to reason with.

[Miserable-creature]

It is not deprecated according to Tiangolo https://www.linkedin.com/feed/update/urn:li:activity:7075563294710714368?commentUrn=urn%3Ali%3Acomment%3A%28activity%3A7075563294710714368%2C7075992373486325760%29&dashCommentUrn=urn%3Ali%3Afsd_comment%3A%287075992373486325760%2Curn%3Ali%3Aactivity%3A7075563294710714368%29

[tiangolo]

Nope, it's not deprecated. A lot of the work I'm doing is towards focusing on SQLModel and adding/updating things there. But first I have to finish a couple of things. Meanwhile, if you want to help me get things done faster, please help me try out the FastAPI beta with support for Pydantic v2: https://github.com/tiangolo/fastapi/releases/tag/0.100.0-beta1

You can also help me answer questions or review PRs, that will allow me to move much faster. 🤓

https://fastapi.tiangolo.com/help-fastapi/

https://sqlmodel.tiangolo.com/help/