News for hackers. Stuff that matters.
Re:SQLite the only database you will ever need in most cases by CodesInChaos on Thursday April 15, 2021 @04:25AM (#26817619)
1. You can run Postgres locally using the same ZFS for storage you'd use for the sqlite database. This should come with the same backup properties as sqlite.

2. I doubt that the git part of your setup can be snapshotted correctly while an operation is in progress, since git doesn't use transactions.

Re:SQLite the only database you will ever need in most cases by theamk on Friday April 16, 2021 @12:02AM (#26829312)
Git does use transactions, in a pretty clever way: the main storage is immutable -- so when you do a new commit, it creates all new files, and as a last step, updates HEAD/branch, using "rename" call which is atomic on all filesystems.

So you can do pretty bad things to git and it would still work. Atomic snapshots are absolutely no problem. Copying the directory while in progress is fine.

If you try very hard, you can still make a bad backup -- say you were copying files from remote host, and backup got interrupted after HEAD but before the new data. In this case, there is reflog -- append-only file which keeps HEAD history. Using this file, you would be able to manually recover into previous state.