Re: [sqlite] .dump command and user_version

2018-03-29 Thread Ian Zimmerman
On 2018-03-29 12:47, Wout Mertens 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 have run into this too. I was trying to transport Mozilla browser "places" database this way, and it turned out their code cares a

Re: [sqlite] .dump command and user_version

2018-03-29 Thread Scott Robison
On Thu, Mar 29, 2018, 8:18 AM Richard Hipp wrote: > On 3/29/18, Scott Robison wrote: > > It seems a > > reasonable to suggestion to add it. > > Version 3.23.0 is in bug-fix-only mode. It'll have to wait. > Of course. I wasn't suggesting that it should be done with all haste, just agreeing wit

Re: [sqlite] .dump command and user_version

2018-03-29 Thread Simon Slavin
On 29 Mar 2018, at 3:10pm, Scott Robison wrote: > 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. On consideration, I see the point. Would you want to dump PRAGMA s

Re: [sqlite] .dump command and user_version

2018-03-29 Thread Richard Hipp
On 3/29/18, Scott Robison wrote: > It seems a > reasonable to suggestion to add it. Version 3.23.0 is in bug-fix-only mode. It'll have to wait. -- D. Richard Hipp d...@sqlite.org ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org htt

Re: [sqlite] .dump command and user_version

2018-03-29 Thread Scott Robison
On Thu, Mar 29, 2018 at 6:56 AM, Simon Slavin wrote: > > > On 29 Mar 2018, at 1:47pm, Wout Mertens 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 ad

Re: [sqlite] .dump command and user_version

2018-03-29 Thread Simon Slavin
On 29 Mar 2018, at 1:47pm, Wout Mertens 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 d

[sqlite] .dump command and user_version

2018-03-29 Thread Wout Mertens
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? sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; COMMIT; sqlite> pragma user_version=5