Re: Not the first piece of absurd preaching to come from the SQLite team
The FAQ doesn't attempt to scope its verdict on threads to SQLite; it does however state an advocacy position, contrary to the norm, citing only a single decade-old paper. Being persuasive is, at best, a fleeting consideration.
But on the whole implementation thing: after the hard stuff of statement parsing SQLite's underlying store is just sorted lists for binary search. So this feels like exactly what readers-writer locks are for: there's a simple, robust, well-documented, well-informed told, widely-implented solution. And then there's just proclaiming a deeply-held conviction.