In my experience most SQLite writes take less than 1ms. So if your app is handling less than a thousand writes per second you will probably be OK!
A common pattern (which I've implemented myself in Datasette) is to put your writes in an in-memory queue and apply them using a single dedicated connection.
A common pattern (which I've implemented myself in Datasette) is to put your writes in an in-memory queue and apply them using a single dedicated connection.