SQLite Forum

Exclusive write-only lock? (Allow only one process read-write, and multiple read-only)
> [...] blocking anyone else from writing while still allowing them to both connect and read.

Could that become an option in SQLite? A "blocking writer (+read) connection",so you won't have to do the IMMEDIATE dance? This as the question seems to come up every now and then. No idea how useful it actually would be.