News for hackers. Stuff that matters.
Re:Making Database Systems Usable by codr7 on Tuesday August 20, 2024 @06:15PM (#41304651)
Easier to reason about in that they don't force you to clarify your thoughts, which will come back to bite your head off. And there's a pretty significant long term price to be paid. I would rather write Cobol than deal with MongoDB.
Re:Making Database Systems Usable by Spivak on Wednesday August 21, 2024 @12:07AM (#41306690)
This is all nice and good but I've never once seen someone correctly clarify their thoughts ahead of time that doesn't end up being the wrong model as the code evolves.

The only schemas that survive long term are the ones that create such a tangled ball of foreign keys that migrations are infeasible. Great advice for anyone looking to leave a legacy.

Re:Making Database Systems Usable by codr7 on Wednesday August 21, 2024 @04:20AM (#41308028)
At least they exist, and force you to refactor the code to match reality.

Document databases tend to take on a life of their own; and since they encourage shortcuts, the slope is typically down.

Re:Making Database Systems Usable by yas_hmaheshwari on Wednesday August 21, 2024 @04:41AM (#41308165)
Nicely put!

I see new grads talking about MERN stack (with M for Mongo), and always have an urge to correct them that replace M with Mysql