Because he produces SQLiteDoctor
That’s why I thought he’d see a lot of corrupted sqlite files.
I just looked at https://www.sqlite.org/threadsafe.html and see that the default for sqlite files at compile time is Serialized. I then checked the sqlite files I use with my Web apps and they are all compiled that way (THREADSAFE = 1, which is Serialized).
[quote]Single-thread. In this mode, all mutexes are disabled and SQLite is unsafe to use in more than a single thread at once.
Multi-thread. In this mode, SQLite can be safely used by multiple threads provided that no single database connection is used simultaneously in two or more threads.
Serialized. In serialized mode, SQLite can be safely used by multiple threads with no restriction.[/quote]
[quote=430104:@Norman Palardy]Unless the app is entirely single threaded EVERY thread of execution should have its own connection
I’m guessing this is where your db went corrupt by sharing one db connection[/quote]
Doesn’t the fact that these sqlite files run in Serialized Mode (as described above) get around this requirement?