[jiggawatts]

Riiiight up to the point that the database needs to be online and running backups at the same time.

When that occurs, your “simple” tech choice suddenly becomes a too simple straitjacket.

[olavgg]

SQLite supports online backup https://www.sqlite.org/backup.html

You can also use Litestream to create snaphots.