safari.db -wal file

Had lots of trouble absorbing the -wal file, I thought I was running a checkpoint through sqlitebrowser but apparently it wasn’t doing anything?

Running sqlite History.db through terminal and PRAGMA wal_checkpoint; and then Ctrl+D like described in the comment here finally ended up working

concurrent writes

See here for some code I used to test concurrent writes/locking/timeouts with sqlite

concurrent reads

yc post has some cool notes about enabling WAL mode to get better concurrent reads