Hi there, I'm developping an application that will use several databases. One on disk that will hold all configuration and cache, and another in ram to hold all live data.
On the same server, it is possible that multiple process will read/write to both the disk db and the memory db. Someone on IRC suggested to create a normal file db instead of memory and place it in a ramfs such as /dev/shm so other process can also connect to it. I'm wondering what I will need to organise to ensure stability for such operations (two or more processes on on database). I beleive I should look into a strong locking policy, but there may be something else... Also, I will need to copy chunks of the database from one to the other in a similar way to a replication. I know that sqlite does nothing about replication, interdatabase communication, etc. I'm just wondering if there could be a query made on a database using information provided in another database (ie to compare, or insert/copy). Thanks in advance, Simon -- When Earth was the only inhabited planet in the Galaxy, it was a primitive place, militarily speaking. The only weapon they had ever invented worth mentioning was a crude and inefficient nuclear-reaction bomb for which they had not even developed the logical defense. - Asimov _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
