I changed SQLITE_THREADSAFE compile-time setting to 2 in response to #703 but consider this to be incorrect. Since the same database connection may be accessed by multiple background threads due to the background thread pool SQLITE_THREADSAFE=1 compile-time setting is wanted required.
The discussion at [1] brought this to my attention. See [2] for reference documentation.
While I do not expect access from multiple threads to the same database connection at the same time, due to the existing queuing mechanism, I would like to fix this for the sake of consistency and predictability.
[1] http://sqlite.1065341.n5.nabble.com/Question-about-threadsafe-td100512.html
[2] https://sqlite.org/compile.html#threadsafe
I changed
SQLITE_THREADSAFEcompile-time setting to2in response to #703 but consider this to be incorrect. Since the same database connection may be accessed by multiple background threads due to the background thread poolSQLITE_THREADSAFE=1compile-time setting iswantedrequired.The discussion at [1] brought this to my attention. See [2] for reference documentation.
While I do not expect access from multiple threads to the same database connection at the same time, due to the existing queuing mechanism, I would like to fix this for the sake of consistency and predictability.
[1] http://sqlite.1065341.n5.nabble.com/Question-about-threadsafe-td100512.html
[2] https://sqlite.org/compile.html#threadsafe