News for hackers. Stuff that matters.

A comment on Surviving Django, if you care about databases. Parent comment

Re:Surviving Django, if you care about databases by dandellion on Friday August 07, 2020 @04:08AM (#24079532)
The Django ORM is excellent as long as you stick to the well-trodden path. But if you want to squeeze every ounce of performance or you know that the execution plan a query generates is not the best or it's not using the right indexes, it's like wearing shackles.

SQLAlchemy on the other hand makes it very easy to do exactly what you need, without even having to drop to writing raw SQL. The way the ORM and the core are structured is the perfect balance of abstraction and control.

[ Parent | on HN ]
Re:Surviving Django, if you care about databases by collyw on Friday August 07, 2020 @09:07AM (#24081362)
I'll agree that the Django ORM isn't very good once your queries get moderately complex. But I have been underwhelmed by SQLalchemy having tried it recently. It's not intuitive compared to Django's and in the end for complex query I just ended up in raw SQL anyway - as I would have in Django's ORM.
[ Parent | on HN ]