undefined | Better HN

0 pointsclncy3d ago0 comments

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.

0 comments

3 comments · 1 top-level

groundzeros20153d ago· 2 in thread

Why is it easier?

You don’t need to operate on the entire database. You can backup or roll back individual tables and schemas.

clncyOP3d ago

You can do it, but if you stuff that process up (e.g. touch the wrong tables/schemas) you’re now dealing with a more complex recovery.

Also are you applying migrations with CREATE OR REPLACE etc? I find that much harder to collaborate on than just standard code.

groundzeros20152d ago

You only need to migrate if you care about the data and once again that can be different for each schema. And the inverse is true, if you don’t migrate it’s because you’re not preserving data.

j / k navigate · click thread line to collapse