4 ms·
That doesn't make the relation model bad, it just means there's an impedance mismatch. FWIW, I find the relational model to be much nicer than typical object m
by wtetzner 6y ago
That doesn't make the relation model bad, it just means there's an impedance mismatch.
FWIW, I find the relational model to be much nicer than typical object models. Even in Java, which I write every day at work, I've found it to be much clearer to use immutable objects representing records. Not just for interacting with the database, but just for handling information in general.
Of course, it would be extremely painful to do without Lombok's @Value, @Builder, and @With annotations.
- achr2 6y agoI 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.
- wtetzner 6y ago> 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.