Comment by reissbaker

Although for SQLite in particular, you can do streaming incremental backups with Litestream: https://litestream.io/