SQLite does not support concurrent writes at all (on a single machine), a single writer process locks the entire database.
It doesn't block reads. Single writer systems are often faster than concurrent writers no coordination overhead and you can batch.
alt Hacker News
It doesn't block reads. Single writer systems are often faster than concurrent writers no coordination overhead and you can batch.