Save sqlite :memory: database to disk
Posted: Thu 07 May 2015 17:51
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?
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?