[scotty79]

If a morbidly obese person dies then saying that maybe they should have eaten less is not really a case of 20/20 hindsight.

If you write a query but don't add an index for the fields in your WHERE ... I don't know what to tell you.

[kayo_20211030]

It's precisely hindsight. It seems harsh to blame the dev who wrote the query for the death of the business. It makes good copy on reddit; funny, and sticky, but harsh. That stuff is bad. The dev should feel bad. But, was that the root cause for the failure; was it even a proximate cause? None of this was teased out satisfactorily in the original piece. All the tech silliness at the failed companies was presented as being both necessary and sufficient for the failures. I feel that there may have been _something_ else, but you'd never know from the original post.

[scotty79]

If the business couldn't hire a dev that knows that you don't write a query without ensuring it uses some index when it runs then the business deserved to die and I wouldn't place any blame on the dev who in business terms is just a resource. Bad resource, but just a resource, so they can't be blamed for the failure of the business.

And the root cause is hiring process that admits devs that can do db api call but have no idea what having database as a component of your app actually entails.