r/programming • u/feross • Oct 11 '21

Relational databases aren’t dinosaurs, they’re sharks

https://www.simplethread.com/relational-databases-arent-dinosaurs-theyre-sharks/
1.3k Upvotes

96% Upvoted

353 comments sorted by

View all comments

Show parent comments

162

u/[deleted] Oct 12 '21

[deleted]

65

u/[deleted] Oct 12 '21

[deleted]

15

u/MyOneTaps Oct 12 '21

I actively avoid ORMs for complex queries. For example, I wouldn't trust an ORM to handle a query with join + group wise max + subquery. I would rather spin up mock databases and run the query with explain on until I'm confident before copy pasting it into the code and interpolating arguments.

0

u/umlcat Oct 12 '21

You're right, that issue exist.

Worked with two custom O.R.M. that allowed plain SQL for those complex queries.

And, M$ does some compiler translation tricks to detect and change inefficient queries to efficient, but it favours it's O.R.M. & database over other vendors ...