On Jan 11, 2016, at 11:57 AM, Simon Slavin <slavins at bigfraud.org> wrote: > > Just do BEGIN IMMEDIATE immediately after you open the database.
Doesn?t that set up a race condition? What prevents the other process from opening the DB and running its own SQL if the OS?s scheduler happens to take the CPU away from the legitimate process between sqlite3_open_v2() and sqlite3_exec(?, ?BEGIN IMMEDIATE?, ?) ?