Comment by tpm - Hacker Neue

tpm Jun 20, 2025 parent

It's not enough, there is no way to represent some db stuff (not relational, more impl oriented) or some special queries in the program with an ORM. No ORM I have seen comes close to 100% of what you could do with the DB. So still the best way to get closest to the db is using raw queries in the program, but of course that does not scale with more tables, does not scale with more db engines, and does not scale with juniors taking over your codebase and not understanding it.

So to conclude, objection-orientation is fine and relational is fine too, the issue is that the optimal way to translate between them does not scale.

eru 2 days ago

I'm with the first part of your comment. But why do you suddenly conclude that object orientation is good?

If your language supports relation, there's no need to badly translate to objects. (And even if your language doesn't support everything your database does, there's still less of an impedance mismatch if you use an 'RRM' instead of an ORM.)

This item has no comments currently.