←back to thread

Software development topics I've changed my mind on

(chriskiehl.com)
873 points belter | 1 comments | 05 Feb 25 09:50 UTC | HN request time: 0.277s | source
Show context
imjonse ◴[05 Feb 25 12:12 UTC] No.42947407[source]▶
> ORMs are the devil in all languages and all implementations. Just write the damn SQL

It depends on what you're writing. I've seen enough projects writing raw SQL because of aversion to ORMs being bogged down in reinventing a lot of what ORMs offer. Like with other choices it is too often a premature optimization (for perf or DX) and a sign of prioritizing a sense of craftsmanship at the expense of the deliverables and the sanity of other team members.

replies(8): >>42947752 #>>42947978 #>>42948317 #>>42948504 #>>42953164 #>>42954817 #>>42956074 #>>42956308 #
1. Twirrim ◴[05 Feb 25 13:54 UTC] No.42948504[source]▶
One job I had, we got handed a code base with at least 4 different reinventions of an ORM in it.

It became clear that each developer who'd worked on the code had written their own helpers to avoid direct SQL. It took a fair bit of persuading leadership, but the first task ended up being doing a huge reactor of everything SQL. Unsurprisingly enough, lots of bugs got squashed that way.