[jakebsky]

We're using SQLite in production with millions of databases with many millions of operations per day. It's been nothing but great, as has always been my experience using SQLite.

But we did run into some scariness around trying to use Litestream that put me off it for the time being. Litestream is really cool (and I'm a big fan of its author!) but it is also very much a cool hack in the way it works.

The scariness I ran into was related to this issue https://github.com/benbjohnson/litestream/issues/510

And after a bit more fiddling I came away nervous about the possibility of corruption, which is not something I want to worry about from my backup method.

So for now we're just doing regular snapshotting with remote backups and that seems sufficient with RAID1 storage. I would like something lower latency at some point but don't have the time at the moment to work on it.