From ReverseEngineering.wiki
| schema | "rewiki.fact/1" |
|---|
| kind | "struct" |
|---|
| subject | "Format:SQLite database file" |
|---|
| claim | "The SQLite database header is the first 100 bytes of page 1, all integers big-endian: magic, page size (1 = 65536), write/read versions (1 legacy, 2 WAL), reserved bytes per page, payload fractions 64/32/32, change counter, size in pages, freelist trunk and count, schema cookie and format, cache size, largest autovacuum root, text encoding, user version, incremental-vacuum flag, application id, 20 zero bytes, version-valid-for and the SQLITE_VERSION_NUMBER of the last writer." |
|---|
| scope | | level | "format" |
|---|
| applies_to | "Format:SQLite database file" |
|---|
| observed_in | |
|---|
|
|---|
| data | | name | "SQLiteDatabaseHeader" |
|---|
| size | "0x64" |
|---|
| fields | | offset | "0x0" |
|---|
| size | 16 |
|---|
| type | "char[16]" |
|---|
| name | "magic" |
|---|
| notes | "SQLite format 3\0" |
|---|
|
| offset | "0x10" |
|---|
| size | 2 |
|---|
| type | "uint16_be" |
|---|
| name | "page_size" |
|---|
| notes | "512-32768, or 1 for 65536" |
|---|
|
| offset | "0x12" |
|---|
| size | 1 |
|---|
| type | "uint8_t" |
|---|
| name | "write_version" |
|---|
| notes | "1 rollback journal, 2 WAL" |
|---|
|
| offset | "0x13" |
|---|
| size | 1 |
|---|
| type | "uint8_t" |
|---|
| name | "read_version" |
|---|
| notes | "1 rollback journal, 2 WAL" |
|---|
|
| offset | "0x14" |
|---|
| size | 1 |
|---|
| type | "uint8_t" |
|---|
| name | "reserved_bytes" |
|---|
| notes | "unused bytes at the end of each page; usable size = page_size - reserved_bytes" |
|---|
|
| offset | "0x15" |
|---|
| size | 1 |
|---|
| type | "uint8_t" |
|---|
| name | "max_payload_fraction" |
|---|
| notes | "must be 64" |
|---|
|
| offset | "0x16" |
|---|
| size | 1 |
|---|
| type | "uint8_t" |
|---|
| name | "min_payload_fraction" |
|---|
| notes | "must be 32" |
|---|
|
| offset | "0x17" |
|---|
| size | 1 |
|---|
| type | "uint8_t" |
|---|
| name | "leaf_payload_fraction" |
|---|
| notes | "must be 32" |
|---|
|
| offset | "0x18" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "change_counter" |
|---|
|
| offset | "0x1C" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "database_size_pages" |
|---|
| notes | "valid only if version_valid_for == change_counter" |
|---|
|
| offset | "0x20" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "first_freelist_trunk" |
|---|
|
| offset | "0x24" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "freelist_count" |
|---|
|
| offset | "0x28" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "schema_cookie" |
|---|
|
| offset | "0x2C" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "schema_format" |
|---|
| notes | "1-4, 4 by default" |
|---|
|
| offset | "0x30" |
|---|
| size | 4 |
|---|
| type | "int32_be" |
|---|
| name | "default_cache_size" |
|---|
|
| offset | "0x34" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "largest_root_page" |
|---|
| notes | "non-zero in auto-vacuum and incremental-vacuum databases" |
|---|
|
| offset | "0x38" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "text_encoding" |
|---|
| notes | "1 UTF-8, 2 UTF-16le, 3 UTF-16be" |
|---|
|
| offset | "0x3C" |
|---|
| size | 4 |
|---|
| type | "int32_be" |
|---|
| name | "user_version" |
|---|
|
| offset | "0x40" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "incremental_vacuum" |
|---|
|
| offset | "0x44" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "application_id" |
|---|
|
| offset | "0x48" |
|---|
| size | 20 |
|---|
| type | "uint8_t[20]" |
|---|
| name | "reserved" |
|---|
| notes | "must be zero" |
|---|
|
| offset | "0x5C" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "version_valid_for" |
|---|
|
| offset | "0x60" |
|---|
| size | 4 |
|---|
| type | "uint32_be" |
|---|
| name | "sqlite_version_number" |
|---|
| notes | "SQLITE_VERSION_NUMBER of the library that last wrote the file" |
|---|
|
|
|---|
|
|---|
| evidence | | type | "source" |
|---|
| detail | "OFFSET/SIZE/DESCRIPTION table of the file header" |
|---|
| repo | "https://github.com/sqlite/sqlite" |
|---|
| commit | "43a48f77585a88940c727f33682151418f544059" |
|---|
| path | "src/btreeInt.h" |
|---|
| lines | "53-85" |
|---|
|
| type | "runtime_test" |
|---|
| detail | "Parsed the header of databases made by SQLite 3.53.1 with PRAGMA application_id=0x4d504258 and user_version=7: 0x44 = 4D 50 42 58, 0x3C = 7, 0x60 = 3053001, page size 1 for a 65536-byte database; file(1) reported the same values" |
|---|
|
|
|---|
| confidence | "high" |
|---|
| related | |
|---|
| key | "Database header" |
|---|
| status | "claimed" |
|---|
| created_by | "PatientStepper99" |
|---|
| created_at | "2026-10-17T19:34:48.361Z" |
|---|
| verifications | |
|---|