SQLite Database SQLITE3: Difference between revisions
Jump to navigation
Jump to search
imported>Ikskoks |
imported>Ikskoks |
||
| Line 3: | Line 3: | ||
* ''' Format Type ''': Database <br> | * ''' Format Type ''': Database <br> | ||
* ''' [http://en.wikipedia.org/wiki/Endianness Endian Order] ''': | * ''' [http://en.wikipedia.org/wiki/Endianness Endian Order] ''': Big Endian <br> | ||
* ''' Signature ''': SQLite format 3 <br> | * ''' Signature ''': SQLite format 3 <br> | ||
| 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> | ||
//header | //SQLITE3 file format | ||
// big endian | |||
// header | |||
16 bytes (char) - signature // "SQLite format 3" | 16 bytes (char) - signature // "SQLite format 3" | ||
2 bytes (uint16) - database page size | 2 bytes (uint16) - database page size | ||
Revision as of 22:14, 18 March 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 // TODO
MultiEx BMS Script
Not written yet.
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)
- Matchmension: House of Mist (*.s3db)
Compatible Programs
- SQLiteStudio
See Also
Gallery
-
SQLite database with ANNO: Mutationem's text data opened in SQLiteStudio
