SQLite Forum

Exclusive write-only lock? (Allow only one process read-write, and multiple read-only)
You could get that result by doing a <code>BEGIN IMMEDIATE</code> and never closing the transaction.  Just use savepoints for what should be transactions.

Of course, other connections won't see your changes.  But in this situation I'm not sure you'd want them to.