Pragmas are listed out here: http://www.sqlite.org/pragma.html
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. Another way of looking at it is to look at what's in the header here: http://www.sqlite.org/fileformat2.html If it doesn't have a spot in the header then there's no way to save the change for subsequent connections. -----Original Message----- From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Adam Jensen Sent: Friday, August 26, 2016 12:55 PM To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Locking databases - Possibly (probably?) a dumb question On 08/25/2016 04:41 PM, Adam Jensen wrote: ... And, as far as I can tell, all of these PRAGMA's seem to persist - they do not need to be reasserted in any way during subsequent database accesses. Do all PRAGMA's, once set to a specific value, stay set? Does anyone have links to the related documentation? _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
