SQLAlchemy vs. SQLModel: Which Python ORM is BEST?

SQLAlchemy and SQLModel are going head to head to see which one is the BEST.

🎓 Courses can be found:

👨‍💻 Hi, I am Eric!👨‍💻
Hey! I’m a seasoned developer and Cloud enthusiast. I love sharing my knowledge and helping others to discover the exciting world of programming and cloud technologies. For more tutorials, tips, and tech magic, don’t forget to hit that subscribe button and ring the bell for notifications!

🙏 Support The Channel 🙏
If you found this tutorial helpful, please give it a thumbs up 👍, comment, and share it with your network 🌍

#python #sqlalchemy #sqlmodel

[definite_d]

While I have used SQLModel myself, it's not my recommendation right now beyond any MVPs or simple CRUD operations.

While it allows you to get started a bit faster, and not need to mentally switch between SQLA and Pydantic, it just isn't sufficient for larger projects. For example, it's unclear how to use PostgreSQL-native table inheritance from SQLModel; you just have to either use SQL or SQLA anyway.

[raphael]

Wouldn't it be better to compare SQLAlchemy + Pydantic vs SQLModel ? I am not sure if SQLModel integrates everythings if you use 2 other stuffs seperately ?

[abcpsc]

SQLmodel's simplicity is attractive at first, but it feels incomplete. As of now, it doesn't even have documentation on database migration.

[codingwithroby]

Would you rather see more SQLAlchemy or SQLModel in the future videos?

[sokchea]

Async connection comparison is missing. Can you elaborate this part?

[eboyd]

I would like to see code comparison videos between the two ORM. I think the idea of data validation being handled by the ORM is interesting and would love to see how these two compare.

[awakenwithoutcoffee]

maybe I'm ignorant here but it seems best to seperate the database models from your validation models ?

[مبشر]

Loved all sqlmodel and sqlalchemy videos. Still waiting for sqlmodel listen for row changes to develop a socket io project

[alchemication]

With AI code generation i would say No to any ORM and write queries myself, and get pydantic to validate requests and responses precisely. The older you get the less abstraction you want to use 🙂

[CoderBoy]

Please make project on fastapi backend and react frontend ❤
I am waiting for you 😢

[kmahendranath]

Just like Albus Dumbledore gave additional points to Gryffindor towards the end of Philospher's stone. You too gave brownie points to SQLModel :D
Great Stuff by you as always

[Nicht-Verstehen]

sqlmodel is nothing without sqlalchemy. comparing apples to apple pie is pretty silly.

[Daniel-flsi]

Sqlmodel lacks of polymorphism, I mean, the real advanced one and for mi it is a dealbreaker.