SQLite Database SQLITE3: Difference between revisions
Jump to navigation
Jump to search
imported>Ikskoks |
imported>Ikskoks (→Games) |
||
| (13 intermediate revisions by the same user not shown) | |||
| Line 11: | Line 11: | ||
<div class="toccolours mw-collapsible" id="mw-customcollapsible-myDivision" style="width:800px; overflow:auto;"> | <div class="toccolours mw-collapsible" id="mw-customcollapsible-myDivision" style="width:800px; overflow:auto;"> | ||
<pre> | <pre> | ||
//SQLITE3 file format | // SQLITE3 file format | ||
// big endian | // big endian | ||
| Line 20: | Line 20: | ||
1 byte (uint8) - file format write version // 1 or 2 | 1 byte (uint8) - file format write version // 1 or 2 | ||
1 byte (uint8) - file format read 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 | |||
| Line 25: | Line 31: | ||
</pre> | </pre> | ||
</div> | </div> | ||
=== Notes and Comments === | === Notes and Comments === | ||
| Line 40: | Line 42: | ||
* ANNO: Mutationem (*.db) | * ANNO: Mutationem (*.db) | ||
* ArcheAge Online (*.sqlite3) (encrypted) | * ArcheAge Online (*.sqlite3) (encrypted) | ||
* Ares Chronicles (PC) (*.db) (not encrypted) | |||
* Matchmension: House of Mist (*.s3db) | * Matchmension: House of Mist (*.s3db) | ||
=== quickBMS Script === | |||
* [https://github.com/bartlomiejduda/Tools/blob/master/NEW%20Tools/SQLITE3/Dump_SQLite3_database_script.bms Dump_SQLite3_database_script.bms] | |||
=== Compatible Programs === | === Compatible Programs === | ||
| Line 63: | Line 70: | ||
[[Category:Extension_sqlite3 | Extension: sqlite3]] | [[Category:Extension_sqlite3 | Extension: sqlite3]] | ||
[[Category:Extension_s3db | Extension: s3db]] | [[Category:Extension_s3db | Extension: s3db]] | ||
[[Category:File Format]] | [[Category:File Format]] | ||
Latest revision as of 22:36, 1 May 2022
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
Compatible Programs
- SQLiteStudio
See Also
Gallery
-
SQLite database with ANNO: Mutationem's text data opened in SQLiteStudio
