> WAL2 + BEGIN CONCURRENT
Woah. There are some gotchas. It still won't support as much concurrency as row-level MVCC. But it'll still be a big improvement.
https://www.sqlite.org/cgi/src/doc/wal2/doc/wal2.md
https://www.sqlite.org/src/doc/begin-concurrent/doc/begin_co...