Avoid it at any cost!
Unfortunately, today I thought of using an ORM for one of my pet projects, as I hadn’t had "the honor" to touch it so far. That was a mistake.
Avoid SQLAlchemy and its twin brothers—SQLModel, PonyORM, and the rest. There's no decent ORM in Python except for Django’s ORM. Everything else is half-baked. So, it's really better to implement your own SQL ORM, or just use plain SQL queries.
An ORM should abstract away database management without you needing to worry about it—no need to manually open sessions, commit, update, or whatever.
It should "just work," like in Django or Rails.
Top comments (0)