sqlite-page-explorer
Dev tools
database debugging visualizer
SHOW HN2025
288points
41comments
#194of 3,837 in 2025
Top 6%of 2025 by points
How HN took it
LovedMost comments that take a side are positive
8 positive, 0 neutral or asking, 1 mixed, 1 critical, out of 10 comments about the project. Thread score +0.50.
Idea: 2 for, 0 againstDocs: 1 for, 0 againstExecution: 0 for, 1 against
The thread, comment by comment
Each row is a top-level comment and its replies, in HN's order. Select a cell to open that comment on HN.
positive neutral or mixed critical about another commenter or something else the maker
What HN said
What people liked
Neat and useful for learning SQLite internals
From 4 comments
Neat! It's surprisingly easy to sit down with a copy of the sqlite file format docs and start writing code to parse sqlite files (like this project does), and I'd strongly…
Retr0id on HNThank you! As someone who isn't disciplined enough to sit through a course or class, this was a really good way to visualize what's going on under the hood, and how to structure…
shlomo_z on HNNeat. Being learning about databases and this is very helpful!
ShaggyHotDog on HNTool works well.
aappleby on HN
Impressive work
From 2 comments
That's really impressive! As someone who's worked with SQLite internals in the past, I know this kind of work and tinkering is no small feat. On a related note, I recently came…
artps on HNA true masterpiece:)
jas39 on HN
Objections
Hard to tell what the colors mean
From 1 comment
This looks cool, nice job. Maybe add a color-legend to the front page? I didn't know what the colors represented at first. It's kind of choking on a larger db (3.6GB, 942719…
ks2048 on HN
Slow on large databases
From 2 comments
This looks cool, nice job. Maybe add a color-legend to the front page? I didn't know what the colors represented at first. It's kind of choking on a larger db (3.6GB, 942719…
ks2048 on HNYou can hover to get the page types (title attributes) and learn the color scheme that way, although it's not super clear. And yeah, large DBs get slow; pages are iterated…
QuadrupleA on HN
Failed to run with a Lua module not found error
From 1 comment
Nice project, unfortunately when I run the executable it throws the error: "failed to run lua code: /index.lua:3: module 'utils' not found:".
rousbound_ on HN
Requests
Add a color legend
From 1 comment
This looks cool, nice job. Maybe add a color-legend to the front page? I didn't know what the colors represented at first. It's kind of choking on a larger db (3.6GB, 942719…
ks2048 on HN
Paginate or live-scroll pages
From 2 comments
This looks cool, nice job. Maybe add a color-legend to the front page? I didn't know what the colors represented at first. It's kind of choking on a larger db (3.6GB, 942719…
ks2048 on HNYou can hover to get the page types (title attributes) and learn the color scheme that way, although it's not super clear. And yeah, large DBs get slow; pages are iterated…
QuadrupleA on HN
Alternatives named
sqlite-repr
From 1 comment
That's really impressive! As someone who's worked with SQLite internals in the past, I know this kind of work and tinkering is no small feat. On a related note, I recently came…
artps on HN
showdb CLI in SQLite source
From 1 comment
The sqlite source includes a CLI tool called showdb that is quite nice for poking around in database files
wwader on HN
Nayuki SQLite file visualizations
From 1 comment
Indeed, the file format is easy to read! It took me a few hours in one sitting to implement a reader. I have some visualization tools too, but with way less features than the…
nayuki on HN