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 ... syntax. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users