Hacker News new | ask | show | jobs
by brightball 1519 days ago
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.

1 comments

Make no mistake, I think DB constraints are a best practice.
They have their place, but also their limits.