Comment by mamcx
6 days ago
Because JS is bad, and JS have a MASSIVE user base, so whatever they do is the web.
And because JS is on the frontend, solutions are front end, even the ones that eventually run on the (js) back-end.
Is like how people use a RDBMS but never do foreign keys, views, etc and re-invent all, poorly.
I had similar thoughts, but how does one use an RDBMS without making use of FKs? Do they put all in one huuuge table, that has all the columns and is super sparse? Or some other fever dream of bad design?
And is even worse, this is stuff that I have seen in ERPs (I integrate with several).
One of them, not even use "date"/"decimal" types and all is mostly strings, there is not views or anything else, and the tables AND fields are called "F0001..".
You can have a field with some value that just happens to match the id in a different table. That something could be a foreign key or just a number.
As long as you don't give a shit about data integrity, you don't need foreign keys.