Re:ORM Is an Offensive Anti-Pattern
by smt88 on Tuesday December 02, 2014 @06:43AM
(#8686651)
SQL sucks, too. I hope we start to see every web framework come with a better, more expressive wrapper for SQL rather than the compulsory ORM.
[ Parent
| on HN ]
In my experience, every time we tried to replace SQL with something else (last time it was Zend Framework with its SQL request builder), the entire project code base turned into a heap of mysteries... Since then, in every project, no matter how complex or simple it is, we try to stay with plain old SQL queries.
Try jOOQ, it's a nice wrapper of SQL
It sucks when you don't understand it, like any other language/technology :) When you understand SQL, it is a powerful implementation of a relational calculus
Been writing SQL for 10 years. I definitely understand it.
The problem is that it's rigid, and constructing queries based on filters or user input is painful. It disrupts the flow of your code.
That's why I now use query builders, which aren't ideal, but they at least allow me to build my queries in a logical order (adding additional ORDER BY conditions, adding/removing JOINs depending on my needs, etc.)
The problem is that no query builder that I've used flows as well as SQL or "gets out of the way".