3 ms·
Never bumped into the "beautiful flexibility" of ERD databases - where the app devs assume all responsibility over things that database designers _really_ shoul
by bigiain 11y ago
Never bumped into the "beautiful flexibility" of ERD databases - where the app devs assume all responsibility over things that database designers _really_ should be saying "Hell no!" to?
+------------+------------+--------------------------------+
| asset_id | asset_name | asset_data |
+------------+------------+--------------------------------+
| 2147483646 | firstName | Joseph |
| 2147483647 | lastName | Bloggs |
|-2147483647 | phoneNumber| +1 415 555 1234 |
|-2147483646 | email | joebloggs@gmal.com |
+------------+------------+--------------------------------+
(I think I still have brain damage from trying to get "too smart" with a Magento eCommerce site once...)
- duaneb 11y agoThe flexibility typically comes from transactions and joins, something document store proponents typically shy away from. And yes, if you give stupid devs powerful tools they will shoot themselves.
- eru 11y agoIt's not only flexibility, but also discipline and taking away choices (for bad modelling) that comes from following the relational normal forms.