On Thu, Mar 29, 2018 at 6:56 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 29 Mar 2018, at 1:47pm, Wout Mertens <wout.mert...@gmail.com> wrote: > >> I noticed that `.dump` does not output the user_version pragma. It seems to >> me that that is part of the database data? >> >> I don't actually use it, but it might be interesting to add this for >> completeness? > > .dump is for things which affect data and data integrity only. "PRAGMA > foreign_keys" is one of the few PRAGMAs which affects data integrity: if a > database is operated with that PRAGMA not set, the data could be corrupted. > > Numerous PRAGMAs have no effect on integrity. For example the journal mode > and page size. They are not included in the output of .dump.
Yet as he said, user_version is data. It can be queried and can be checked to make decisions about what to do with the data. It seems a reasonable to suggestion to add it. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users