Comment on What if we treated Postgres like SQLite?parentComments−markuswOP11moYeah, basically the same here, except it's Caddy in front instead of Traefik.So you do periodic backups, not incremental on every write or something (read replica-like)?It's important to me to not lose any data once committed if at all possible.(For testing, I've sped everything up by running migrations on `template1` and every test gets a random database name. Works wonders.)−8organicbits11moGood catch. I am doing periodic, not incremental, backups on that system. It all depends on risk, cost, and tolerance for data loss.
Comments
Yeah, basically the same here, except it's Caddy in front instead of Traefik.
So you do periodic backups, not incremental on every write or something (read replica-like)?
It's important to me to not lose any data once committed if at all possible.
(For testing, I've sped everything up by running migrations on `template1` and every test gets a random database name. Works wonders.)
Good catch. I am doing periodic, not incremental, backups on that system. It all depends on risk, cost, and tolerance for data loss.