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
___
sqlite
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" section on the
download pag
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 wrote:
> The file header
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 big-endian
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
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.
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:
software
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
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 o
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 number
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 versi
11 matches
Mail list logo