While I love postgres, I take issue with coupling too much application logic to the DB. It’s much easier to update/rollback stateless containers/cloud functions/VMs than to recover a DB.
Why is it easier?
You don’t need to operate on the entire database. You can backup or roll back individual tables and schemas.
Why is it easier?
You don’t need to operate on the entire database. You can backup or roll back individual tables and schemas.