Re: [sqlite] Is it possible to connect to an in-memory sqlite

2016-11-14 Thread Hick Gunter
ntag, 14. November 2016 20:39 An: sqlite-users@mailinglists.sqlite.org Betreff: Re: [sqlite] Is it possible to connect to an in-memory sqlite I am very interested in the answer to this question. Currently it seems like the only way to get multiple connection to the in-memory db is with 'c

Re: [sqlite] Is it possible to connect to an in-memory sqlite

2016-11-14 Thread Richard Hipp
On 11/14/16, Daniel Meyer wrote: > > Is the right approach to write a custom VFS? > https://www.sqlite.org/src/artifact/e5225bc22e79dde6 -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://maili

Re: [sqlite] Is it possible to connect to an in-memory sqlite

2016-11-14 Thread Simon Slavin
On 14 Nov 2016, at 7:38pm, Daniel Meyer wrote: > I am very interested in the answer to this question. Currently it seems > like the only way to get multiple connection to the in-memory db is with > 'cache=shared' and I understand that subsequent connections opened to that > memory database are

Re: [sqlite] Is it possible to connect to an in-memory sqlite

2016-11-14 Thread Daniel Meyer
> > pNode=0x60251760) + 424 at sqlite3.c:184602 > > frame #8: 0x0001110c31b1 > > sqlite3`fts5ExprNodeFirst(pExpr=0x60251370, > > pNode=0x600000679400) + 225 at sqlite3.c:184579 > > frame #9: 0x0001110c2ff5 > >

Re: [sqlite] Is it possible to connect to an in-memory sqlite db in Read-Only mode?

2016-11-12 Thread Simon Slavin
On 11 Nov 2016, at 12:28pm, Bhargava Srinarasi 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 > | SQL