Re: [sqlite] Version of the database

On 5/26/16, John G wrote: > I don't see the '.dbinfo' command in the shell in the version supplied > with MacOS X 10.10 (Yosemite) - 3.8.8.3. > Was this introduced after this. Added in 3.8.9 (2015-04-08) -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] Version of the database

On 26 May 2016, at 5:31pm, John G wrote: > Was this introduced after this. Yes, it's a very recent new thing. > I know Apple is a bit slow in updating, but I can't use a personally > compiled verion. Download the precompiled version from the "Precompiled Binaries"

Re: [sqlite] Version of the database

I don't see the '.dbinfo' command in the shell in the version supplied with MacOS X 10.10 (Yosemite) - 3.8.8.3. Was this introduced after this. I know Apple is a bit slow in updating, but I can't use a personally compiled verion. John G On 5 May 2016 at 23:42, R Smith

[sqlite] Version of the database

The file header contains the SQLite version that most recently modified the schema. You can see this using the cli, but not a pragma. If you are willing to dig a bit, you can retrieve it by reading the first 100 bytes or so from the file and examining the 4 bytes at offset 96. It's a

[sqlite] Version of the database

2016-05-05 18:19 GMT+02:00 Simon Slavin : > > On 5 May 2016, at 5:15pm, Cecil Westerhof wrote: > > > I know how to get the version of the running version of SQLite, but is > > there a way to get the version with which the database was created? > > Unfortunately I do not think this information is

[sqlite] Version of the database

On 5 May 2016, at 5:38pm, Richard Hipp wrote: > There is no PRAGMA to retrieve this, but you can see it by > running the ".dbinfo" command in the shell. I was wrong. Believe Richard, not me. Simon.

[sqlite] Version of the database

2016-05-05 18:15 GMT+02:00 Cecil Westerhof : > > I know how to get the version of the running version of SQLite, but is > there a way to get the version with which the database was created? > ?With the command line program I can get it with: .dbinfo one of the things it gives is:

[sqlite] Version of the database

I know how to get the version of the running version of SQLite, but is there a way to get the version with which the database was created? -- Cecil Westerhof

[sqlite] Version of the database

On 5 May 2016, at 5:22pm, Cecil Westerhof wrote: > ?With the command line program I can get it with: >.dbinfo > one of the things it gives is: >software version:3008010 I don't know if this is from something stored in the file. My guess is that it's more likely to be the version

[sqlite] Version of the database

On 5 May 2016, at 5:15pm, Cecil Westerhof wrote: > I know how to get the version of the running version of SQLite, but is > there a way to get the version with which the database was created? Unfortunately I do not think this information is stored anywhere. One often finds three version

[sqlite] Version of the database

On 5/5/16, Simon Slavin wrote: > > On 5 May 2016, at 5:15pm, Cecil Westerhof wrote: > >> I know how to get the version of the running version of SQLite, but is >> there a way to get the version with which the database was created? > > One often finds three version numbers stored: > > A) The