SQLite Database SQLITE3

Back to index | Edit this page

SQLITE3, DB, S3DB

• Format Type : Database
  
• Endian Order : Big Endian
  
• Signature : SQLite format 3
  

Format Specifications

// SQLITE3 file format

// big endian

// header
16 bytes (char) - signature // "SQLite format 3"
2 bytes (uint16) - database page size
1 byte (uint8) - file format write version  // 1 or 2
1 byte (uint8) - file format read version  // 1 or 2
1 byte (uint8) - bytes of unused space at the end of each page
1 byte (uint8) - maximum embedded payload fraction  // must be 64
1 byte (uint8) - minimum embedded payload fraction   // must be 32
1 byte (uint8) - leaf payload fraction  // must be 32
4 bytes (uint32) - file change counter
4 bytes (uint32) - size of the database file in pages


// TODO

Notes and Comments

• Database total size can be calculated like this:
  • End_offset = Start_offset + (page_size * num_of_pages)
  • Total_size = End_offset - Start_offset

Games

List of games using this file format:

• ANNO: Mutationem (*.db)
• ArcheAge Online (*.sqlite3) (encrypted)
• Ares Chronicles (PC) (*.db) (not encrypted)
• Matchmension: House of Mist (*.s3db)

quickBMS Script

• Dump_SQLite3_database_script.bms

Compatible Programs

• SQLiteStudio

See Also

• SQLite Database file format (sqlite.org)

Gallery

• 

  SQLite database with ANNO: Mutationem's text data opened in SQLiteStudio