3 ms·
Me thinks someone needs to have a go at maintaining a 2Mloc accounting package built using only embedded SQL statements and stored procedures, including migrati
by codr7 7y ago
Me thinks someone needs to have a go at maintaining a 2Mloc accounting package built using only embedded SQL statements and stored procedures, including migrating the whole mess between major database vendors.
I guess one advantage is you have to learn, it but I really prefer some kind of ORM for more mundane repetitive CRUD. More to get a structured (ha!) interface between the database and the application than for the convenience.
I do wish most of them would stop insisting on putting the cart in front of the horse and make code the primary representation.
- ianamartin 7y agoI deal with that. Millions of lines of SQL stored procs. It's awful, but not anything an ORM could help with.
- codr7 7y agoNot all of it, but I'm sure most statements follow some kind of CRUD pattern. Getting that out of the way is exactly what an ORM can help with.