Sqlite Page Explorer
50+
Downloads
Everyone
info
About this app
This application lets the user open Sqlite databases and explore the internal organisation of various objects such as tables and indices. To understand how Sqlite3 data is organised, please see Database file format from Sqlite website.
SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine.
Applications:
- Viewing internal organisation of Sqlite databases for software development, ethical hacking 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 trunk and leaf pages
User guide:
On pressing 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 pressing on the Open: button at the bottom.
SQLite is a self-contained, high-reliability, embedded, full-featured, public-domain, SQL database engine.
Applications:
- Viewing internal organisation of Sqlite databases for software development, ethical hacking 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 trunk and leaf pages
User guide:
On pressing 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 pressing on the Open: button at the bottom.
Updated on
Safety starts with understanding how developers collect and share your data. Data privacy and security practices may vary based on your use, region, and age. The developer provided this information and may update it over time.
No data shared with third parties
Learn more about how developers declare sharing
No data collected
Learn more about how developers declare collection
What’s new
Update targetSdkVersion to 34
App support
About the developer
Arundale Ramanathan
arun@siara.cc
Old no 45/1 new no 80, Valmiki Street,
Thiruvanmiyur near bus stop
Chennai, Tamil Nadu 600041
India
undefined
