3 ms·
> DB constraints can be a hindrance if the business rules are in flux, and you already have them in the app layer What you here mean as "DB Constraints" if not
by nerdyadventurer 5y ago
> DB constraints can be a hindrance if the business rules are in flux, and you already have them in the app layer
What you here mean as "DB Constraints" if not FK and etc?
- paulryanrogers 5y agoCheck constraints can compare new values against bounds different than the column's type definition. Like maintaining a SMALLINT between 1-100. Or one could even write trigger based checks that ensure integrity among multiple records' values. (Though I don't recommend it unless the constraints are unlikely to change or one has little control over app layer validation.)