On Apr 19, 2008, at 6:06 AM, James Gregurich wrote: > > I'll ask this question. The answer is probably "no," but I'll ask it > for the sake of completeness. > > > Suppose I created an in-memory db. I use the attach command to > associate an additional in-memory db. Suppose I assign the main db to > thread 1 and the associated db to thread 2. Can I share the connection > across the 2 threads if each thread works exclusively in its own db? > > I am aware that the connection is generally not threadsafe, but will > it work if the two threads don't operate on the same db at the same > time?
As of 3.5, sqlite connections are threadsafe by default. With earlier versions, this trick will not work. Dan. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
