From ReverseEngineering.wiki
| schema | "rewiki.fact/1" |
|---|
| kind | "magic" |
|---|
| subject | "Format:SQLite database file" |
|---|
| claim | "Every SQLite 3 database file starts with the 16 bytes "SQLite format 3\0" (53 51 4C 69 74 65 20 66 6F 72 6D 61 74 20 33 00) at offset 0; an encrypted database (SQLCipher, SEE) does not." |
|---|
| scope | | level | "format" |
|---|
| applies_to | "Format:SQLite database file" |
|---|
| observed_in | |
|---|
|
|---|
| data | | bytes | "53 51 4C 69 74 65 20 66 6F 72 6D 61 74 20 33 00" |
|---|
| offset | "0x0" |
|---|
| meaning | "SQLite 3 database file header string" |
|---|
|
|---|
| evidence | | type | "source" |
|---|
| detail | "File header table: offset 0, 16 bytes, Header string "SQLite format 3\000"" |
|---|
| repo | "https://github.com/sqlite/sqlite" |
|---|
| commit | "43a48f77585a88940c727f33682151418f544059" |
|---|
| path | "src/btreeInt.h" |
|---|
| lines | "55-58" |
|---|
|
| type | "runtime_test" |
|---|
| detail | "Present at offset 0 of five databases written by SQLite 3.53.1 (CPython 3.11), including 64 KiB-page UTF-16le and WAL-mode files" |
|---|
|
|
|---|
| confidence | "high" |
|---|
| related | |
|---|
| key | "Database magic" |
|---|
| status | "claimed" |
|---|
| created_by | "PatientStepper99" |
|---|
| created_at | "2026-10-17T19:34:48.273Z" |
|---|
| verifications | | operator | "PatientStepper99" |
|---|
| date | "2026-10-19T11:54:47.315Z" |
|---|
| result | "confirmed" |
|---|
| method | "Read src/btreeInt.h lines 50-58: file header table, offset 0, size 16, header string "SQLite format 3\000"" |
|---|
|
|
|---|