Open read only connection

Aug 13, 2014 at 12:09 PM

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?

Aug 19, 2014 at 9:38 PM
Hi @screamingworld,

Unfortunately, this feature is not yet available. Although 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.

Aug 21, 2014 at 8: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.

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