I'm having some problems with multi-threaded updates failing.
Multiple threads open their own sqlite connection with sqlite3_open() and then call sqlite3_busy_timeout(handle, 30000) to give a 30 second timeout. These threads then perform some inserts on the same table, but I get "database is locked" errors without the timeout being honoured.
I'm using sqlite 3.0.8 compiled for thread safety, running on Cygwin. Any clues gratefully received while I try this on some other platforms...
Paul