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 <rsm...@rsweb.co.za> wrote: > 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 32-bit integer containing the version, and also another 32-bit > integer (4-byte) value just prior at offset 92 is a counter of how many > changes were made since using that library version. Together these can be > quite useful information. > > The Integer value of the version would be a number like this: 3012034 - > starting with a 3 always for SQLite3 and then the next 3 digits the minor > version (12 in the example) and the last 3 the release (34 in the example). > > For more information on values stored in the header - see here: > https://www.sqlite.org/fileformat2.html#database_header > > Cheers, > Ryan > > > On 2016/05/05 6:22 PM, Cecil Westerhof wrote: > >> 2016-05-05 18:15 GMT+02:00 Cecil Westerhof <cldwester...@gmail.com>: >> >> 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 version: 3008010 >> so it is 3.8.10,but would it also be possible to get in my Java program? >> >> > _______________________________________________ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
