You can do things like this in Postgres as well - my point was that the database are designed to solve distributed systems problems, so your database of choice

You can do things like this in Postgres as well - my point was that the database are designed to solve distributed systems problems, so your database of choice is a good place to solve those problems. I couldn't make a universal statement about where the constraints you're talking about should go without knowing the business rules for the application.