On 18 Mar 2019, at 3:21pm, Jonathan Moules <jonathan-li...@lightpear.com> wrote:

> At this point I'm starting to think that the best option is to create a new 
> database with the requisite structure and copy the data across via an ATTACH 
> (there are only two tables and one will almost always be empty at this point).

That could work well.  Create the new database and set

    PRAGMA journal_mode = OFF

then close it, attach it to your main database and use the 

    INSERT INTO table SELECT ...

sqlite-users mailing list

Reply via email to