[wild_egg]

> SQLite definitely seems like a poor choice for dealing with many concurrent requests

Can you qualify "many"? SQLite easily handles 100k+ writes per second and it's not hard to have app layer code serialize and batch writes to take advantage of that speed. Concurrent writes require a ton of overhead and your system and code can be quite a lot faster and simpler if you just skip the idea of them altogether.

[inigyou]

SQLite serialises all writes - only one can proceed at a time and others must wait until that one is finished

[victorbjorklund]

Writes are fast unless you are doing some complex transaction stuff.

[inigyou]

Each one includes a few fsyncs