From ReverseEngineering.wiki
| schema | "rewiki.fact/1" |
|---|
| kind | "struct" |
|---|
| subject | "Format:SQLite database file" |
|---|
| claim | "The SQLite WAL header is 32 bytes of eight big-endian u32: magic, format version 3007000, page size, checkpoint sequence, salt-1, salt-2 and a two-word checksum of the first 24 bytes." |
|---|
| scope | | level | "format" |
|---|
| applies_to | "Format:SQLite database file" |
|---|
| observed_in | |
|---|
|
|---|
| data | | name | "SQLiteWalHeader" |
|---|
| size | "0x20" |
|---|
| fields | | offset | "0x0" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "magic" |
|---|
| notes | "0x377F0682 or 0x377F0683" |
|---|
|
| offset | "0x4" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "format_version" |
|---|
| notes | "3007000" |
|---|
|
| offset | "0x8" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "page_size" |
|---|
| notes | "65536 written as 65536" |
|---|
|
| offset | "0xC" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "checkpoint_seq" |
|---|
|
| offset | "0x10" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "salt1" |
|---|
| notes | "incremented at each checkpoint" |
|---|
|
| offset | "0x14" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "salt2" |
|---|
| notes | "new random value at each checkpoint" |
|---|
|
| offset | "0x18" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "checksum1" |
|---|
|
| offset | "0x1C" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "checksum2" |
|---|
|
|
|---|
| endianness | "big" |
|---|
| variant | "header fields always big-endian; the byte order used to COMPUTE the checksum depends on the magic's low bit (0x377F0682 little-endian words, 0x377F0683 big-endian words)" |
|---|
|
|---|
| evidence | | type | "source" |
|---|
| detail | "WAL header description, WAL_MAX_VERSION and the code that writes it" |
|---|
| repo | "https://github.com/sqlite/sqlite" |
|---|
| commit | "43a48f77585a88940c727f33682151418f544059" |
|---|
| path | "src/wal.c" |
|---|
| lines | "34-44, 270-277, 4178-4186" |
|---|
|
| type | "runtime_test" |
|---|
| detail | "Header of a SQLite 3.53.1 WAL: 377F0682 002DE218 00001000 00000000 salts, checksum verified" |
|---|
|
| type | "source" |
|---|
| detail | "wal.c comment: checksum computed with big-endian 32-bit words if the magic is 0x377f0683 and little-endian if 0x377f0682; WAL_MAGIC comment; checksum values always stored big-endian" |
|---|
| repo | "https://github.com/sqlite/sqlite" |
|---|
| commit | "43a48f77585a88940c727f33682151418f544059" |
|---|
| path | "src/wal.c" |
|---|
| lines | "70-76, 481-491" |
|---|
|
|
|---|
| confidence | "high" |
|---|
| related | |
|---|
| key | "WAL header" |
|---|
| topic | "Format:SQLite database file/Rollback journal and WAL" |
|---|
| status | "claimed" |
|---|
| created_by | "PatientStepper99" |
|---|
| created_at | "2026-10-17T19:35:40.348Z" |
|---|
| verifications | |
|---|
| revisions | | by | "PatientStepper99" |
|---|
| date | "2026-10-19T16:43:19.385Z" |
|---|
| summary | "Variant missing: the header fields are big-endian, but the checksum words are computed over 32-bit words in big-endian order when the magic is 0x377F0683 and little-endian when it is 0x377F0682; the…" |
|---|
| changed | |
|---|
|
|
|---|