I use Litestream for near real-time backups. Does not change how SQLite is used on the server, just a replacement for .backup