[innocenat]

Where is write contention coming from if it's operated locally?

[Thaxll]

SQLite is "single" threaded for writes.

[d3nj4l]

... you can get tons of requests on a server?

[dinosaurdynasty]

Redis has the same limitation (only one transaction at a time) and is used a lot for webapps. It solves this by requiring full transactions up front. The ideal case for sqlite for performance is to have only a single process/thread directly interacting with the database and having other process/threads send messages to and from the database process.

[innocenat]

But that isn't "locally"?