3 ms·
ORM gets in the way of programming. ORM abstracts which something developers know as his/her fundamentals : SQL statements. For simple operations this abstract
by samblr 9y ago
ORM gets in the way of programming.
ORM abstracts which something developers know as his/her fundamentals : SQL statements. For simple operations this abstraction doesn't hurt. But this abstraction becomes obfuscation when we write complex queries or statements.
First a developer has to figure out complex SQL query to solve a business problem. Then has to figure ORM equivalent to it. Then ,ofcourse one should, write original SQL query in comment section above ORM API query to help figure whilst debugging.
Once into debugging, if original SQL query is missing in comment section or hasn't been updated. Spend extra time on what is wrong with both queries. Which one is right/wrong and then how to solve the problem.
Although, I do see some value in ORM in migrating to another DB or abstracted objects of tables-and-properties.
But for simple reason of learning additional set of apis to run SQL statements hurts!