3 ms·
I'd rather learn the ins and outs, problems and issues, highs and lows, of SQL rather than an ORM. ORM require just as much investment in time and even then yo
by andrewstuart 9y ago
I'd rather learn the ins and outs, problems and issues, highs and lows, of SQL rather than an ORM.
ORM require just as much investment in time and even then you still need to learn the sql to get the ORM to do what you want it to do.
SQLAlchemy on Python is a truly fine piece of software but in the end it was much simpler and felt more powerful for me to write the SQL. And not even hard BTW.
I only have a limited amount of time available for learning and if I can trim out an entire class of technology (i.e. the ORM) then that's a whole bunch of stuff I just don't need to spend time learning.
- mythrwy 9y agoI prefer SQL to ORMs as well for exactly the reason you state. It's more comfortable and it's less of a mystery. But you don't always get to pick what code you'll be working with and if you are working with others in a web framework pretty good chance you'll be learning an ORM anyway. Also really long SQL statements are no fun. Like debugging a whole program written in one line. I think sometimes there is a temptation to get excessively clever with SQL.