On 08/26/2016 01:20 PM, David Raymond wrote: [snip] > Many do not persist after closing your connection, including synchronous and > foreign_keys that you mentioned. In fact, I'd say that the number that do > persist is pretty small, and those that do usually require a vacuum or such > after being issued so that a new value can get put in the header, or the file > is reorganized, etc. [snip]
Wow, thanks! That's a very relevant detail that doesn't seem to be documented anywhere and I probably would have continued with the misunderstanding until something went very wrong (or worse, incomprehensible system behavior led to frustration and eventual abandonment). _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users