Thanks you for your tips. I will keep those in mind.

Since the database used is sqlite, it is simply a file on the filesystem. I back it up using rsnapshot.

Currently I am testing on my laptop so maybe I will just use rsync to backup to external drives for now.

I recommend DB Browser

Yesterday I was searching how to open sqlite file and found this and installed it. It is great to visually see how the data are stored in sqlite database.