On 11 Nov 2016, at 12:28pm, Bhargava Srinarasi <[email protected]> wrote:
> I know that I can open multiple connections to an In-Memory sqlite database > using file:DB_NAME?mode=memory&cache=shared in sqlite3_open_v2(). > > I open 2 connections to an In-Memory database. One with the flags > SQLITE_OPEN_URI > | SQLITE_OPEN_CREATE | SQLITE_OPEN_READWRITE and another with > SQLITE_OPEN_READONLY > | SQLITE_OPEN_URI. > > The problem is that sqlite lets me modify the database even when the > connection is Read/Write. Whether the connection is Read-Only is controlled by the cache. Since you are using cache=shared, all connections have the same setting for Read/Write. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
