On Fri, May 24, 2013 at 5:03 PM, Roland Hughes <[email protected]>wrote:
> "file:memdb1?mode=memory&cache=shared", > > It ends up creating files in the executable directory. > Have you tried using ":memory:"? Each instance of an in-memory db opened that way is unique, despite the non-unique name: sqlite> attach ':memory:' as m1; sqlite> attach ':memory:' as m2; sqlite> create table m1.t (a,b,c); sqlite> create table m2.t (a,b,c); sqlite> insert into m1.t values(1,2,3); sqlite> insert into m2.t values(4,5,6); sqlite> select * from m1.t; 1|2|3 sqlite> select * from m2.t; 4|5|6 -- ----- stephan beal http://wanderinghorse.net/home/stephan/ http://gplus.to/sgbeal _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
