SQLite does not support concurrent writes at all (on a single machine), a single writer process locks the entire database.

> you seem like the inexperienced one to me

There is irony here