News for hackers. Stuff that matters.

A comment on Making Database Systems Usable. Parent comment

Re:Making Database Systems Usable by Taikonerd on Wednesday August 21, 2024 @01:58PM (#41312588)
> crud apps end up with thousands of nearly identical queries which are mostly just boringly spelling out the chain of joins that needs to be applied.

I think EdgeDB [0] is on the right track here. It's a database built on Postgres, but with a different query language. So instead of manually fiddling with JOIN statements, traversing linked tables just looks like dot notation:

    select BlogPost.author.email; # get all author emails
[0] https://www.edgedb.com/
[ Parent | on HN ]
Re:Making Database Systems Usable by Izkata on Wednesday August 21, 2024 @02:26PM (#41312826)
Django is a python web framework over 15 years old that's also very similar to what GP wants. For example their apple->box->house query would be something like:

  Apple.objects.get(box__house__owner = 'pjs_')
Still have to specify "box", but the actual foreign key relationships are defined on the models so you don't do the full JOIN statements anywhere.
[ Parent | on HN ]