I havent seen any such functions, but you can write your own code to copy data from one db (in-memory) to another (on disk). Copy pasting example from another thread: attach second.db as second insert into main.table (select * from second.table) detach second -- You could also implement something to only copy what has changed since last time, or you could attach different files every time to create full snapshots -- Another way, on linux, is to create a disk-based database and store it in ram disk such as /dev/shm, and then just copy this file back on disk (say using cron?).
HTH, Simon On Tue, Jan 27, 2009 at 5:28 PM, DeTerra, David J <david.j.dete...@boeing.com> wrote: > Hi all, > > I was wondering if there is a feature in sqlite that would allow a set > of in-memory databases to periodically be written to disk for purposes > of database recovery on application or machine failure? > > And then subsequently read those persisted database files back into a > memory database on restart? > > Thanks, > David > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- 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
