Sqlite Page Explorer Alternatives
Sqlite Page Explorer
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`.
Best Sqlite Page Explorer Alternatives
Looking for the best programs similar to Sqlite Page Explorer? Check out our top picks. Let's see if there are any Sqlite Page Explorer alternatives that support your platform.
MySQL Community Edition
FreeOpen SourceMacWindowsLinuxBSDMySQL is a Open Source Relational DataBase Management System, using InnoDB technology. .
Features:
- Database
- MariaDB
- Relational database
SQLite
FreeOpen SourceMacWindowsLinuxAndroidiPhoneSelf-HostedSQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL...
Features:
- Cross-platform
- In-memory database
- Lightweight
- Web-Database
- Database
- Embeddable
- Import from SqlServer
- In-process file-based
- Relational database
phpMyAdmin
FreeOpen SourceWebPHPphpMyAdmin is a tool written in PHP intended to handle the administration of MySQL over the Web. Currently it can create and drop databases, create/drop/alter tables...
MySQL Workbench
FreeOpen SourceWindowsProvides data modeling, SQL development, and comprehensive administration tools for servers.
Features:
- Database
- GUI Designer
- Server Management
- Spell checking
DBeaver
FreemiumOpen SourceMacWindowsLinuxEclipseJavaDBeaver - Universal Database Manager and SQL Client. DBeaver is free and open source (GPL) universal database tool for developers and database administrators. ...
Features:
- Data export/import
- Autocompletion
- Database Management
- ER Diagrams
- Foreign key linking
- Function Key Shortcuts
- Material design
- Night mode/Dark Theme
- PostgreSQL support
- Restore on reboot
- Support for Oracle
- Built-in viewer
- Clean design
- Database Management
- Dedicated Server Hosting
- Export to CSV
- MongoDB
- Multiple DataBase
- Night mode/Dark Theme
- Portable
- Smooth lines
- Ssh tunnel
- Tabbed interface
PostgreSQL
FreeOpen SourceMacWindowsLinuxBSDPostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of active development and a proven architecture that has earned it a...
Features:
- Database
- Relational database
HeidiSQL
FreeOpen SourceWindowsLets you view and edit data from MariaDB, MySQL, Microsoft SQL, or PostgreSQL databases.
Features:
- Lightweight
- Data export/import
- Database
- IDE
- Night mode/Dark Theme
- Portable
- Server Variables Manager
- Simple import
- Ssh tunnel
MongoDB
FreeOpen SourceMacWindowsLinuxWebBSDMongoDB is a document database with the scalability and flexibility that you want with the querying and indexing that you need MongoDB stores data in flexible...
Features:
- NoSQL database
- Database
MariaDB
FreeOpen SourceWindowsLinuxBSDMariaDB is an Open Source Relational DataBase Management System, using InnoDB technology. .
Features:
- Database
- Relational database
DataGrip
CommercialMacWindowsLinuxDataGrip is a database IDE from JetBrains that is tailored to suit specific needs of professional SQL developers. — Intelligent query console Allows you to write...
Features:
- Autocompletion
- PostgreSQL support
- Database
- Database Management
- Editable grid
- Idea
Upvote Comparison
Interest Trends
Sqlite Page Explorer Reviews
Add your reviews & share your experience when using Sqlite Page Explorer to the world. Your opinion will be useful to others who are looking for the best Sqlite Page Explorer alternatives.