wal

Compiling and running sqlite3-rsync

Today I heard about the sqlite3-rsync command, currently available in a branch in the SQLite code repository.

Enabling WAL mode for SQLite database files

I was getting occasional messages from a Datasette instance that was running against a bunch of different SQLite files that were updated by cron scripts (my personal Dogsheep).