We use WAL with synchronous=normal and autocheckpoints disabled. Instead we checkpoint manually from time to time from a dedicated thread. More details in the abstraction/sqlite.rs file I linked above. Currently the page size is 2048 but I plan to change that to 4096 soon.