Richard Hipp wrote...
On 8/4/17, jose isaias cabrera <jic...@barrioinvi.net> wrote:
Right now, when I went to a machine that I had upgraded with a
snapshot, I saw that the version was 3.20.0. But when I compared the DLL
file size and date, they were different. It would be nice for
pre-releases
to have something to distinguish them with the new one.
That "something" is the "source-id". You can access the source-id
from C-code using
SQLITE_SOURCE_ID (https://sqlite.org/c3ref/c_source_id.html)
or
sqlite3_sourceid() (https://sqlite.org/c3ref/libversion.html)
Or you can access the information from SQL using
sqlite_source_id()
(https://sqlite.org/lang_corefunc.html#sqlite_source_id)
The 3.20.0 release version has a source-id of
"2017-08-01 13:24:15
9501e22dfeebdcefa783575e47c60b514d7c2e0cad73b2a496c0bc4b680900a8"
The snapshots have an earlier date. You can trace the version of
SQLite you are running back to a particular source-code repository
check-in using the hash. Let $HASH be some prefix of the hash shown
at the end of the source-id. (8 characters is usually plenty.) Then
you can find the check-in, in context, by visiting
"sqlite3.org/src/timeline?c=$HASM". For example:
https://sqlite.org/src/timeline?c=9501e22d
Thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users