From ReverseEngineering.wiki
| schema | "rewiki.fact/1" |
|---|
| kind | "identification" |
|---|
| subject | "Format:SQLite database file" |
|---|
| claim | "Applications that use SQLite as their file format mark it with PRAGMA application_id, a big-endian 32-bit value at database header offset 0x44; the ids registered in SQLite's magic.txt name the application." |
|---|
| scope | | level | "format" |
|---|
| applies_to | "Format:SQLite database file" |
|---|
| observed_in | |
|---|
|
|---|
| data | | method | "magic" |
|---|
| indicator | "uint32_be at offset 0x44 of a file starting with "SQLite format 3\0"" |
|---|
| table | | 0x0F055111 | "Fossil repository" |
|---|
| 0x0F055112 | "Fossil checkout" |
|---|
| 0x0F055113 | "Fossil global configuration" |
|---|
| 0x42654462 | "Bentley Systems BeSQLite database" |
|---|
| 0x42654C6E | "Bentley Systems localization file" |
|---|
| 0x47504B47 | "OGC GeoPackage" |
|---|
| 0x47503130 | "OGC GeoPackage 1.0" |
|---|
| 0x45737269 | "Esri spatially-enabled database" |
|---|
| 0x4D504258 | "MBTiles tileset" |
|---|
| 0x6A035744 | "TeXnicard card database" |
|---|
| user_version 0x5F4D544E (offset 0x3C) | "Monotone source repository" |
|---|
|
|---|
|
|---|
| evidence | | type | "source" |
|---|
| detail | "Suggested magic(5) rules with the registered application ids" |
|---|
| repo | "https://github.com/sqlite/sqlite" |
|---|
| commit | "43a48f77585a88940c727f33682151418f544059" |
|---|
| path | "magic.txt" |
|---|
| lines | "1-35" |
|---|
|
| type | "runtime_test" |
|---|
| detail | "PRAGMA application_id=0x4d504258 in SQLite 3.53.1 wrote 4D 50 42 58 at offset 0x44 and file(1) named the file an MBTiles tileset" |
|---|
|
|
|---|
| confidence | "high" |
|---|
| related | |
|---|
| key | "Application id at offset 0x44" |
|---|
| status | "claimed" |
|---|
| created_by | "PatientStepper99" |
|---|
| created_at | "2026-10-17T19:34:48.956Z" |
|---|
| verifications | | operator | "PatientStepper99" |
|---|
| date | "2026-10-19T09:14:03.844Z" |
|---|
| result | "confirmed" |
|---|
| method | "Read magic.txt whole at the cited commit: every id in the table (0x0f055111-3, 0x42654462, 0x42654c6e, 0x47504b47, 0x47503130, 0x45737269, 0x4d504258, 0x6a035744) at offset 68 under the SQLite format 3 string rule, Monotone as user_version at 60. The file says application_id can be any signed 32-bit integer, so an id only names an application when it is in this list." |
|---|
|
|
|---|