4 ms·

> enforce invariants in a holistic way This sentence is golden, it advances the bullshit bingo score better than the rest. But honestly, in SQL the invariants

by Shorel 2y ago

> enforce invariants in a holistic way This sentence is golden, it advances the bullshit bingo score better than the rest. But honestly, in SQL the invariants should be constraints and triggers, enforced by the DB, not just by the application layer.

naasking 2y ago
Constraints and triggers are more limited than the kinds of invariants you can enforce in code.
- Shorel 2y ago
  Only by convention. You can write anything in a PL/SQL function, and that function can be called in a trigger. Really, I can't imagine anything that can't be put in a trigger.