In my experience most SQLite writes take less than 1ms.

Do your writes really need to be concurrent if they run that fast?

Hard to get upset about waiting for the current write to complete before you get your turn when we are talking delays measured in thousandths of a second.

If you have more than 1000 writes per second then maybe this is something to worry about. The solution there is probably to run a slightly more powerful server!