[sqlite] In-memory database (:memory:) shared between mutlipe threads in same process?

2008-07-11 Thread Markus Lehmann
hi, [repost after earlier posting was mangled up with some HTML tags] I did some tests with the in-memory database and didn't find any way to use the in-memory database from multiple db handles in the same process. Having this capability would enable a multithreaded application to have e.g. mu

Re: [sqlite] In-memory database (:memory:) shared between mutlipe threads in same process?

2008-07-10 Thread Dennis Cote
[EMAIL PROTECTED] wrote: > if( (flags & BTREE_PRIVATE)==0 //FIXME-XXX originally this is > “&& isMemdb==0”    && isMemdb==1 >    && (db->flags & SQLITE_Vtab)==0    > && zFilename && zFilename[0]   ) // FIXME-XXX > originally this is strcmp(zFulPathname, …)if( > 0==strcm

[sqlite] In-memory database (:memory:) shared between mutlipe threads in same process?

2008-07-10 Thread xu123
hi, actually after a quick and dirty hack in btree.c's sqlite3BtreeOpen() things _seem_ to work correctly. Of course this is not in any way how it should be done, but I didn't see a quick way to give in-memory databases a name so that can be used in the search for existing in-memory databases