Is there a consensus on where to check constraint: on the database side or in the application code?

Question

Database design

Logically, restrictions on possible data values ​​are part of the data model that is implemented in a particular schema. It turns out that it is more correct to produce a check constraint on the database side.
Is it so? Maybe there is another point of view?

Answer 1

There is depends on the system and requirements. There will be no unequivocal answer because everything is always trade-off