[sqlite] SQLite in multi-thread application

2015-07-04 Thread Simon Slavin
On 3 Jul 2015, at 4:15pm, ALBERT Aur?lien wrote: > - Using a mutex, only a single thread can write to the database (but > reads can happen during this time) > > But I have sometimes "Database is locked" errors. > > Did I miss something in my configuration ? > Did I miss something in my

[sqlite] SQLite in multi-thread application

2015-07-04 Thread Keith Medcalf
> I'm using SQLite v3.8.8.3 in my muli-threaded application. > > SQLite is configured so these asserts are satisfied : > > assert(sqlite3_threadsafe() > 0); > assert(sqlite3_config(SQLITE_CONFIG_MULTITHREAD) == SQLITE_OK); > > I have multiple connections to the same database file

[sqlite] SQLite in multi-thread application

2015-07-03 Thread ALBERT Aurélien
Hi, I'm using SQLite v3.8.8.3 in my muli-threaded application. SQLite is configured so these asserts are satisfied : assert(sqlite3_threadsafe() > 0); assert(sqlite3_config(SQLITE_CONFIG_MULTITHREAD) == SQLITE_OK); I have multiple connections to the same database file : -