On Thu, May 7, 2015 at 11:53 AM, Paul Sanderson < sandersonforensics at gmail.com> wrote:
> 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? > There is a backup API available that will copy all data from one database to another. See http://sqlite.org/backup.html for details. -- Scott Robison
