Re: [sqlite] sharing in memory db through threads

2018-11-06 Thread Wasilios Goutas
thanks for the hint to https://sqlite.org/uri.html I changed the open statement to make use of URI sqlite3_open_v2("file::memory:?cache=shared", _shared, SQLITE_OPEN_URI | SQLITE_OPEN_READWRITE, NULL ) and it works as expected :) > Wasilios Goutas hat am 5. November

[sqlite] sharing in memory db through threads

2018-11-05 Thread Wasilios Goutas
Hi, I try to use an in memory database which works as long as I use as db path ":memory:". To speed up pre-processing and importing of data I would like to grand several threads access to the same in memory database and have found the documentation on https://www.sqlite.org/inmemorydb.html