Take a Dump

Full video is here: https://youtu.be/z6LUgup3bs0
---
Backing up a sqlite database is extremely simple.

Now, you can just copy the file of the database
but in some rare cases that might corrupt some data
It is better to run the

.dump

you can do this by having a cronjob just doing

`sqlite3 yourdatabase.db “.dump" mybackup.sql`

There’s also newer solution such as litestream
but again I like to be conservative
and dumping works well.