The approach described in Alex's article also opens up another possibility, storing your application's state (contained in the SQLite database) as plain text in a git repo. In fact, this is the approach I take with my Homebrew packages bot. Instead of using sqlite3
, I use Simon Willison’s sqlite_utils
package to do the dump and restore directly from the bot's Python code.