GitHub - QuadrupleA/sqlite-page-explorer: Visual tool to explore SQLite databases page-by-page, the way they're stored on disk and the way SQLite sees them.
SQLite Page Explorer
A small GUI application built in redbean that lets you explore your SQLite databases "page by page" the way SQLite sees them.
Why?
SQLite (and most databases) store data in disk-block-sized pages, usually 4KB, which helps make reads and writes as fast as possible.
Normally developers interact with databases on the "schema level" - tables, rows, and SQL. But taking a peek at the "page level" can give you some interesting insights:
What your indexes actually look like on disk ...
Read more at github.com