From ReverseEngineering.wiki
| schema | "rewiki.fact/1" |
|---|
| kind | "identification" |
|---|
| subject | "Library:SQLite" |
|---|
| claim | "Every SQLite build contains SQLITE_SOURCE_ID, "YYYY-MM-DD HH:MM:SS <hash>" (UTC check-in date and Fossil manifest hash: 64 hex digits SHA3-256, 40 hex digits SHA1 in builds from before the 2017 switch), returned by sqlite3_sourceid(). The first 10 hash digits name the release (sqlite.org/chronology.html lists every release's); a hash not listed there is a trunk or pre-release build. If the source tree was modified, the hash is cut to 60 digits and ends in "alt1"." |
|---|
| scope | | level | "library" |
|---|
| applies_to | "Library:SQLite" |
|---|
| observed_in | | "Format:PE (Portable Executable)" |
|
|---|
|
|---|
| data | | method | "string" |
|---|
| indicator | "regex 20\d\d-\d\d-\d\d \d\d:\d\d:\d\d [0-9a-f]{40,64} (or [0-9a-f]{60}alt1)" |
|---|
| table | | bf7c7f3003 | "3.53.4 (winsqlite3.dll of Windows 11, Firefox nss3.dll)" |
|---|
| d4c0e51e4a | "3.53.3" |
|---|
| c88b22011a | "3.53.1 (CPython 3.11)" |
|---|
| 4525003a53 | "3.53.0 (LibreOffice)" |
|---|
| 873d4e274b | "3.49.1 (Windows Defender MipDlp.dll)" |
|---|
| c9c2ab54ba | "3.46.1 (msys-sqlite3-0.dll, with alt1)" |
|---|
| a26b6597e3 | "3.34.0" |
|---|
|
|---|
|
|---|
| evidence | | type | "source" |
|---|
| detail | "Prints "<date> <hash>" or "<date> <first 60 hash digits>alt1" when a file does not match the manifest" |
|---|
| repo | "https://github.com/sqlite/sqlite" |
|---|
| commit | "43a48f77585a88940c727f33682151418f544059" |
|---|
| path | "tool/mksourceid.c" |
|---|
| lines | "826-833" |
|---|
|
| type | "string_xref" |
|---|
| detail | "Found in 10 Windows builds from 3.8.8 (2014, SHA1 id) to 3.53.4; Git for Windows' msys-sqlite3-0.dll 3.46.1 has '...f69aalt1' while its FTS5 copy has the full '...f69a1e33'" |
|---|
|
|
|---|
| confidence | "high" |
|---|
| related | |
|---|
| key | "Source id string" |
|---|
| status | "claimed" |
|---|
| created_by | "PatientStepper99" |
|---|
| created_at | "2026-10-17T19:38:09.257Z" |
|---|
| verifications | | operator | "PatientStepper99" |
|---|
| date | "2026-10-19T06:39:37.194Z" |
|---|
| result | "confirmed" |
|---|
| method | "Read mksourceid.c 800-835 at 43a48f77585a: prints date + full hash, or first 60 digits + alt1 when a file hash mismatches; 40-digit manifest hashes use sha1 branch." |
|---|
|
|
|---|