Use APKPure App
Get Sqlite Page Explorer old version APK for Android
ศึกษาฐานข้อมูล SQLite ที่แท้จริง !! สำรวจวัตถุเช่นตาราง & ดัชนี
Open Sqlite databases and explore the internal organisation of various objects such as schema, tables and indices. To understand how Sqlite3 data is organised, please see [Database file format](https://www.sqlite.org/fileformat.html) from Sqlite website.
Applications:
- Viewing internal organisation of Sqlite databases for software development and troubleshooting
- Studying the format of Sqlite databases for academic purposes
- Forensic investigators may use it to view data from deleted pages
Features:
- Opening Sqlite databases, displaying first page (containing header and schema root)
- Opening internal pages which may be a B-Tree page, Freelist page or Overflow page
- Exploring root, internal and leaf pages of B-Tree pages hierarchically.
- Parsing and displaying cell content for B-Tree pages
- Exploring Freelist (deleted) trunk and leaf pages
Usage:
On clicking the `Open database` button, the user can select the database file to explore. The application opens the header, finds out the page size and provides links for the user to expand the `Header` and `Page 1`.
The first page invariably contains the header and the schema (definitions of tables and indices). If the schema fits into the first page, the definitions can be seen on the `Page details` section in the form of table under `Cells` heading.
For exploring data of tables and indices, the `Open` button against each table/index under `Cells` section may be clicked. This opens the `root` page of the table or index. Further exploration can be carried out from there by clicking on buttons in the `Page details` sections.
If the schema spills over more than one page, the first page contains links to the different pages in which schema information is stored. These links can be seen in the `Page details` section under `Cells` heading and `Open` button against `Right most pointer` just above `Cells`.
For each page, the page content in bytes is shown in `Hex`, `Decimal` and `Text` representations. It is also possible to open a random page from the database by entering page number and clicking on the `Open:` button at the bottom.
About Sqlite (from their website):
SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine. SQLite is the most used database engine in the world.
SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. SQLite database files are a recommended storage format by the US Library of Congress.
Last updated on Oct 15, 2019
First version on Android
อัปโหลดโดย
Yosnelsy Garcia Vargas
ต้องใช้ Android
Android 4.4+
Category
รายงาน
Sqlite Page Explorer
1.0 by Siara
Oct 15, 2019