Very cool. Is the bottleneck under load mostly SQLite write throughput, or the WAL notification layer?
notifs are extremely cheap, either in the old stat(2) mode or the new PRAGMA page_version (see my update on feeback comment). Some other comments mentioned that stat(2) is about 1µs.