News for hackers. Stuff that matters.
Re:SQLite the only database you will ever need in most cases by mulander on Thursday April 15, 2021 @05:03AM (#26817957)
The only problem with atomic filesystem snapshots is the time required to perform recovery which can be avoided. The recovery process is of course reliable.
Re:SQLite the only database you will ever need in most cases by CodesInChaos on Thursday April 15, 2021 @05:26AM (#26818160)
Does recovery take a long time? Do you have any numbers?

I'd have expected recovery to take time proportional to the size of recent/uncommitted transactions, which should be quick, even for large databases.

Re:SQLite the only database you will ever need in most cases by mulander on Thursday April 15, 2021 @05:51AM (#26818339)
I don't have experience with large SQLite databases. I had PostgreSQL take over 40 minutes for recovery on a 2 TB database set to checkpoint every 30 minutes. How long it takes will depend on the WAL size, the frequency of checkpoints and the operations that were performed before a crash/snapshot.