On 4/12/17, Jens Alfke <j...@mooseyard.com> wrote: > Many of SQLite's pragma commands change database settings. It would be > helpful if their documentation[1] stated which of these persist across > closing/reopening the database, and which are scoped only to the open > connection. For example, the docs say that that 'pragma journal_mode=WAL' is > persistent. Presumably 'mmap_size' is not because it doesn't have any effect > on file storage. But there are some I'm unsure about: > > auto_vacuum, page_size — Persistent? > journal_size_limit, synchronous — Ephemeral?
Yes. Which other PRAGMAs are you interested in? > > I'm asking because I'd like to know which pragmas I need to reissue every > time the database connection is opened, and which I only need to issue when > initializing a new database. > > —Jens > > [1]: http://www.sqlite.org/pragma.html > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users