Backing up a SQLite db from fly.io

sqlite powers my micro-blogging app tohray on flyio. The database file is mounted on a volume as can be seen this fly.toml file:

[[mounts]]
  source = 'db'
  destination = '/mnt/db'

and the actual dbFile is configured as: const dbPath* = "/mnt/db/tohray.db"

I have plans to continue to develop tohray using some ideas from the knowledge lakehouse post from Xinye Tao.

After googling how to copy the sqlite file down, it was as simple as:

$ fly sftp get /mnt/db/tohray.db tohray.db

I think this makes (keeps) fly + sqlite a very attractive target for applications like tohray — one programmer hacking on an application, with state being stored in sqlite, and backup being just a file-copy away.