3 ms·
I don't need to know assembly to write a web app - it's totally magic, and it's fine. However, if I am using an abstraction like an ORM without understanding w
by renegade-otter 3y ago
I don't need to know assembly to write a web app - it's totally magic, and it's fine.
However, if I am using an abstraction like an ORM without understanding what is happening with the database under the hood, or why it's getting slow all of a sudden, it is bound to bite me in the ass.
I shudder to think of how much money and energy the world is burning every second just because of this one alone.
- Nihilartikel 3y agoA client of mine is enduring growth induced ORM hell right now. The struggle and existential threat is real. It can take days for them to even track an evil SQL query back to the actual code. There were fetch-one calls that literally carry a million rows back over the wire for that one returned entity. Indices get skipped due to the magic translation of a row.col.toUpper()=="STRING" into SQL.. when the db collation is case insensitive in the first place. But hey, the devs don't need to know SQL, so there's that.
- renegade-otter 3y agoThe solution is to go "web scale" and add a technology with magical indexes and no transactions because IT FAST! What could possibly go wrong.
- Nihilartikel 3y agoWell, I have heard the word 'Mongo' uttered in passing....