Sqlite Page Explorer

    Cross Platform app to explore internal organisation of tables and indices

    • Free • Open Source
    • Mac
    • iPhone
    • iPad
    ...

    What is 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`.
    Show full description ▾

    Features Vote on or suggest new features

    Comments and Reviews Post a comment / review
     all • positive • negative      relevance • date

    No comments or reviews, maybe you want to be first?

    Categories

    Development • Office & Productivity

    Tags

    • Database
    • sqlitetool
    • sqlite-manager
    Sqlite Page Explorer

    Links and Download

     Official WebsiteDownload from Mac App StoreDownload from iPhone App Store

    Other

    GitHub
    Sqlite Page Explorer

    Summary

    Our users have written 0 comments and reviews about Sqlite Page Explorer, and it has gotten 0 likes

    • Developed by Siara Logics
    • Open Source and Free product.
    • 113 alternatives listed

    Popular alternatives

    View all
    Sqlite Page Explorer was added to AlternativeTo by POX on May 28, 2019 and this page was last updated Sep 18, 2019.

    Recent user activities on Sqlite Page Explorer