How does dropping the existing table and recreating it affect FKs pointing to the table that is being dropped??
Do the FK relationships get destroyed??
You gotta redo the foreign key constraints in the same transaction that you rebuild the table
Oh so specify the FKs from table B to A (if we were dropping and rebuilding A) in a begin/end transaction block?
Thank you
In my case the data was always 10s of MBs.
Remember, the point of SQLite is a replacement for generating a file format. Although it's a database, it lets us (developers) re-use our knowledge of databases when doing basic file I/O.