Dumb Q: what would happen if you used this to store a SQLite database? Would it just... work?

My guess is this would only enable a read-replica and not backups as Litestream currently does?

SQLite’s locking is not NFS safe so this would not work.

SQLite works great with ZeroFS: https://github.com/Barre/ZeroFS