It should be "is aimed at a single process having access to one or more distinct but shareable in-memory databases"
The keys are that you have neither shared cache nor named in-memory databases without URI filenames. Therefore, each connection opening a memory database will get a unique memory database for that connection. The URI format allows you to "name" the memory database and to "share" the cache between connections (effectively permitting you to open multiple connections to the same in memory database from within the same process. --- () ascii ribbon campaign against html e-mail /\ www.asciiribbon.org > -----Original Message----- > From: [email protected] [mailto:sqlite-users- > [email protected]] On Behalf Of Kevin Benson > Sent: Tuesday, 28 May, 2013 06:31 > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Correct way to open multiple in memory databases > > On Tue, May 28, 2013 at 7:57 AM, Roland Hughes > <[email protected]>wrote: > > > ":memory:" is a one-shot wonder. The example from the documentation > > allowed multiple threads to use the _same_ in memory database. > > > > > Am I not understanding the explanation on that page correctly? My > understanding would be that > > "file:memdb1?mode=memory&cache=shared" > > is aimed at a single process having access to two or more distinct but > shareable in-memory databases. > > "If two or more distinct but shareable in-memory databases are needed in a > single process, then the mode=memory > <http://www.sqlite.org/uri.html#coreqp>query parameter can be used > with a URI > filename <http://www.sqlite.org/uri.html> to create a named in-memory > database:" > -- > -- > -- > --Ô¿Ô-- > K e V i N > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
