News for hackers. Stuff that matters.
Re:Making Database Systems Usable by boxed on Wednesday August 21, 2024 @12:23PM (#41311743)
Heh. I was just going to comment on how Djangos ORM is great because it cleanly and transparently solves the number one problem of the paper: the horrible joins.

SQLAlchemy however falls flat on its face in this regard.

Re:Making Database Systems Usable by globular-toast on Wednesday August 21, 2024 @05:33PM (#41314400)
Django makes querying easier by generating the code for the joins, but you're still joining tables.

The point about SQLAlchemy was specifically about the issue mentioned by the GP, namely having to make more tables for composites. SQLAlchemy does a better job of mapping db tables back to regular objects. With Django you get the `alias_set` stuff but it never lets you forget that this is really a database table. Django uses the active record pattern while SQLAlchemy is a data mapper.