2 ms·
The iron law of data is that there should be one source of truth. It’s always better to enforce constraints statically (in this case by the schema) than dynami
by zarzavat 4y ago
The iron law of data is that there should be one source of truth.
It’s always better to enforce constraints statically (in this case by the schema) than dynamically at runtime. Because avoiding inconsistencies is the human’s job, the computer sure as hell won’t know what to do about it.
- wruza 4y agoNot sure I understand a context for this, since checks and triggers are as static as views in a schema sense, and all of them are dynamic in a sense of computation (though get updated at different times). If you mean that columns/fields should not share parts of the same “fact” even if one of them is computed or both are constrained accordingly, then I disagree.