News for hackers. Stuff that matters.
Re:We Can Do Better Than SQL by achr2 on Tuesday August 11, 2020 @01:18PM (#24122860)
I agree that the mismatch is not a direct failing of SQL or the relational model - but we continue to use it without adopting a better approach or developing a common abstraction layer. With all of the syntax growth, SQL could certainly have a join syntax that understands object composition and returns structured data.
Re:We Can Do Better Than SQL by wtetzner on Thursday August 13, 2020 @02:17PM (#24146391)
> With all of the syntax growth, SQL could certainly have a join syntax that understands object composition and returns structured data.

I mean, many RDBMS's have support for JSON and/or XML, so you can sort of get it.

However, I wonder if we'd be better of as an industry if we dealt with our data in code in a more relation-y way than an object-y way.