Just use a thread as a DB handler.  Queue transactions to it using some 
IPC mechanism like a message queue or named pipe.  Another way would be 
to synchronize access to the DB handle using a mutex.

James Gregurich wrote:
> hi!
> 
> 
> I need to set up multiple writers to an in-memory datastore. I just  
> discovered that you can't have more than one connection to an in- 
> memory store.
> 
> I can give each task its own independent datastore if there is a way I  
> can merge the contents of each store into a central store. Is there a  
> way to attach an existing  in-memory store to another in-memory store?
> 
> If not, how hard would it be to modify the sqlite source to allow such  
> an attachment to be made given the two connection pointers to two  
> independent stores?
> 
> 
> thanks,
> James Gregurich
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to