I think it’s a balance. Transactions + Constraints can enforce most things but there will certainly be things that can only be verified in the app. My goal is

I think it’s a balance. Transactions + Constraints can enforce most things but there will certainly be things that can only be verified in the app. My goal is always to verify what I can in the database to minimize potential data cleanup. In my experience, app only verification always leads to future time investments to clean up the mess.