"The second advantage of WAL-mode is that writers do not block readers and readers to do not block writers. This is mostly true" - coming to you live from the part where this is not true. #sqlite3 https://sqlite.org/wal.html
@bert_hubert if you actually need that non-blocking behavior you should use SQLite backed by LMDB. Sqlightning or lumosql.