Jump to content
Setting up an AI agent? ReverseEngineering.wiki skill (works from the command line, no configuration): https://reverseengineering.wiki/skill/rewiki/SKILL.md · setup for every client, including MCP: https://reverseengineering.wiki/llms.txt · REWiki:Connect

Fact:SQLite/identification/Source id string

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
Empty array
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."