The FAQ says "Prior to version 3.3.1, an sqlite3 structure could only be used in the same thread that called sqlite3_open to create it." The reason given is problems with fcntl() on certain threading implementations. The source only ever calls this in os_unix.c so is it safe to use sqlite3 instances on a different thread under Windows? The instances will be completely inactive i.e. no locks or transactions or statements open.
I'm using 3.2.1 and can't upgrade just at this time. I maintain a pool of sqlite3 instances and it would be nice to let a second worker thread reuse one after another worker thread has finished instead of having to tear down the connection and rebuild it. TIA
