3 ms·
The reason pure SQL people and ORM proponents don't always get along is that ORMs make it very easy to write really crappy queries. I'm fully in the ORM camp, b
by wlievens 16y ago
The reason pure SQL people and ORM proponents don't always get along is that ORMs make it very easy to write really crappy queries. I'm fully in the ORM camp, but it is true that I can't turn on SQL statement logging without being terribly embarassed. And tuning and optimizing these queries isn't always as trivial as some make it sound. For fetching some data, it's not terribly hard, but try explaining to Hibernate that you want to bulk delete a bunch of objects (with inheritance) without screwing up your session...
- kunley 16y agoIt's all about people, not the ORMs or other technical inventions. Most shithead queries I encountered during years of DBAing were written by hand by poor folks abandoned by their colleagues and over-confident managers. Just no one cared to educate them, but everyone expected "progress" from them. So they did what they could.. In fact I wished many times that they used some abstraction layer which would save them from doing such harm, simply because this layer would be written by more educated people.