Thanks Marc - it's the latter, very dynamic. Paul www.sandersonforensics.com skype: r3scue193 twitter: @sandersonforens Tel +44 (0)1326 572786 http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit -Forensic Toolkit for SQLite email from a work address for a fully functional demo licence
On 7 May 2015 at 18:55, Marc L. Allen <mlallen at outsitenetworks.com> wrote: > Don't you already have to have a DB initialization script to create the > in-memory database? Couldn't you use that to create the on-disk database, > and then have a separate script to copy all the data over? > > Or is this for more of a dynamic database whereby the users can add/remove > tables and indexes? > > -----Original Message----- > From: sqlite-users-bounces at mailinglists.sqlite.org > [mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Paul > Sanderson > Sent: Thursday, May 07, 2015 1:53 PM > To: General Discussion of SQLite Database > Subject: [sqlite] saving :memory:database to disk > > I am contemplating a change to a program whereby a database is initailly > created in memory and then later if my users choose they can save it to disk > and then switch to using the disk based DB. > > I can obviously create a new disk based db, iterate through sqlite_master and > then populate each table. But I just wondered whether anyone had any > suggestions of a better way of doing this? > > Thanks. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > This email and any attachments are only for use by the intended recipient(s) > and may contain legally privileged, confidential, proprietary or otherwise > private information. Any unauthorized use, reproduction, dissemination, > distribution or other disclosure of the contents of this e-mail or its > attachments is strictly prohibited. If you have received this email in error, > please notify the sender immediately and delete the original. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users