Me thinks someone needs to have a go at maintaining a 2Mloc accounting package b... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

codr7 on Sept 20, 2019 | parent | context | favorite | on: What ORMs have taught me: just learn SQL (2014)

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 on Sept 20, 2019 [–]

I deal with that. Millions of lines of SQL stored procs.

It's awful, but not anything an ORM could help with.

codr7 on Sept 20, 2019 | [–]

Not 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.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact