The Daily WTF
Relational databases have very different constraints on how they structure and store data than most programming languages- tables and relationships don’t map neatly to objects. They also have very different ways in which they can be altered. With software, you can just release a new version, but a database requires careful alterations lest you corrupt your data.
There are many ways to try and address that mismatch in our software, but sometimes the mismatch isn’t in our software, it’s in our brains.
Peter was going through an older database, finally migrating its schema definition into scripts that can be source-controlled. This particular database had never received any care from the database team, and instead all of the data modeling was done by developers. Developers who might not have been quite ready to design a database system from scratch.
The
To read the full article click on the 'post' link at the top.