Open read only connection

Aug 13, 2014 at 11:09 AM
Hello,

how can I open the connection in read only mode...
In other libraries this will work. And when I can not will this take affect on performance?

bye
Markus
Developer
Aug 19, 2014 at 8:38 PM
Hi @screamingworld,

Unfortunately, this feature is not yet available. Although SQLite.org provides an sqlite3_open_v2 method, which allows us to pass a READ_ONLY flag, this method is not available on all platforms. Since we want to avoid inconsistent behavior between platforms, we won't be shipping this feature yet.

Regards,
Developer
Aug 21, 2014 at 7:21 PM
Hi @screamingworld,

I'm sorry for the previous reply, there was some incorrect information. The confusion raised because the native C/C++ method 'sqlite3_close_v2' is not supported on all platforms, but 'sqlite3_open_v2' is; it is the latter which provides extra parameters to set access modes (like READ_ONLY).

We'll address this new feature request in the next release.

Regards,
Marked as answer by marianosz on 11/25/2014 at 7:22 AM