4 ms·
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.
by smt88 12y ago
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.
- bibonix 12y agoTry jOOQ, it's a nice wrapper of SQL
- yegor256a 12y agoIt 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
- collyw 12y agoThe syntax is a bit sucky. The relational model is not.
- smt88 12y agoBeen 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".
- kunkelast 12y agoIn 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.