3 ms·
I see so many blog posts from folks tweaking an algorithm or examining a data structure or describing a programming practice that is perceived to be superior to
by ttfkam 4y ago
I see so many blog posts from folks tweaking an algorithm or examining a data structure or describing a programming practice that is perceived to be superior to another (with varying quality, but that's the internet).
There is a relative Boötes Void of info being posted about relational data architecture and strategies. I came to realize most developers just regard the database as a dumb bit bucket, just as the author here used to. When all you know is an ORM, a database looks pretty dumb. Just model the relational data to match your object model?!
Smart developers care a lot more about the data structures they use than their choice of programming language or even algorithm. And the relational database engines manage the most fundamental data structures at scale. But folks will do almost anything to avoid learning the details of their database engine to point they'll shun even looking at SQL.
It's madness. As an industry we leave so much data validation, performance, and flexibility on the floor while fighting with access troubles further downstream when there's not much we can do about it anymore.
Some foreign key and check constraints could have prevented more data integrity issues than I can count. Some well placed indexes can literally solve performance problems from top to bottom. Row-level security at the data layer has exposed and mitigated so many bugs in app code.
To echo the author: "Don't design your database like a front end developer"