On Wed, 4 Aug 2004, Rajesh Nagarajan wrote:
Hi
I am trying to move to memory database from file based sqlite db, I want my memory database to be shared across various threads in my process.
How do I do it?
From the Wiki documentation, I found the following
* (defvar db2 (sql:connect '(":memory:") :database-type :sqlite :make-default nil :if-exists :old))
+ Will this "if-this:old" help me do this? + Is it supported in V3.x? + I read in the documentation that "Copy" command will no longer be supported (V3.0 onwards), then how do we get to prepare the memory db, any ideas/suggestions for doing that? + Is it possible to have multiple processes running on the same machine with separate memory database, while the threads inside a process share the same memory database?
Can somebody give me a c++ syntax for doing this...or point me to a document that explains more on this?
Thanks & Regards Rajesh
if you are on some *nix system you may want to look into simply using /dev/shm
~ > sqlite /dev/shm/memory.db 'create table foo(bar)'
~ > cp /dev/shm/memory.db ~/notmemory.db
it's cheap and cheerful if you have access to it.
-a
--
===============================================================================
| EMAIL :: Ara [dot] T [dot] Howard [at] noaa [dot] gov
| PHONE :: 303.497.6469
| A flower falls, even though we love it;
| and a weed grows, even though we do not love it. | --Dogen
===============================================================================
