HackerBook
Data
sqlite archive
SHOW HN2025
How HN took it
16 positive, 35 neutral or asking, 1 mixed, 14 critical, out of 66 comments about the project. Thread score +0.02.
Idea: 9 for, 0 againstExecution: 1 for, 6 againstDesign: 1 for, 6 againstPerformance: 1 for, 2 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
Clever sharded-file approach that avoids fetching the full database
From 2 comments
Don't miss how this works. It's not a server-side application - this code runs entirely in your browser using SQLite compiled to WASM, but rather than fetching a full 22GB…
simonw on HNVfs support is amazing.
tehlike on HN
Fun and useful offline archive idea
From 2 comments
It'd be great if you could add it to Kiwix[1] somehow (not sure what the process is for that but 100rabbits figured it out for their site) - I use it all the time now that I have…
kamranjon on HNBeautiful ! 2026 prayer: for all you AI junkies—please don’t pollute H/N with your dirty AI gaming. Don’t bot posts, comments, or upvote/downvote just to maximize karma. Please.…
solarized on HN
Objections
Site is slow to load and query performance is poor on large queries
From 2 comments
22gb for mostly text? tried loading the site, it's pretty slow. curious how the query performance is with this much data in sqlite
dmarwicke on HNI tried "select * from items limit 10" and it is slowly iterating through the shards without returning. I got up to 60 shards before I stopped. Selecting just one shard makes…
kristianp on HN
Does not work well on Firefox or Safari
From 2 comments
Site does not load on Firefox console error says 'Uncaught (in promise) TypeError: can't access property "wasm", sqlite3 is null' Guess its common knowledge that…
Sn0wCoder on HNNo I've seen that error too, on Safari. I think it's related to the wasm being sent with wrong headers. CF pages _headers file should be ensuring correctness. Can you try busting…
keepamovin on HN
Design is hard to use on mobile
From 1 comment
Is it a thing that the design is almost unusable on a mobile phone? The tech making this possible is beyond cool, but it's just presented in such a brutal way for phone users,…
adamszakal on HN
Requests
Mobile-friendly layout
From 2 comments
Is it a thing that the design is almost unusable on a mobile phone? The tech making this possible is beyond cool, but it's just presented in such a brutal way for phone users,…
adamszakal on HNAwesome work. Minor bug/suggestion: right-aligned text inputs (eg the username input on the “me” page) aren’t ideal since they are often obscured by input helpers (autocomplete…
ComputerGuru on HN
Offline archive packaging for Kiwix
From 1 comment
It'd be great if you could add it to Kiwix[1] somehow (not sure what the process is for that but 100rabbits figured it out for their site) - I use it all the time now that I have…
kamranjon on HN
Include comment scores in the archive
From 1 comment
It's really a shame that comment scores are hidden forever. Would the admins consider publishing them after stories are old enough that voting is closed? It would be great to…
modeless on HN
Questions
Where can the data be downloaded and is the repo public
From 2 comments
How do I download it? That repo is a 404.
KomoD on HNlink no workie: https://github.com/DOSAYGO-STUDIO/HackerBook
diyseguy on HN
Whether HN terms of use permit this
From 1 comment
Alas, HN does not belong to us, and the existence of projects like this are subject to the whims of the legal owners of HN. From the terms of use [0]: """ Commercial Use: Unless…
abetusk on HN
Alternatives named
sql.js-httpvfs
From 1 comment
Don't miss how this works. It's not a server-side application - this code runs entirely in your browser using SQLite compiled to WASM, but rather than fetching a full 22GB…
simonw on HN
sqlite-s3vfs
From 1 comment
There was a UK government GitHub repo that did something interesting with this kind of trick against S3 but I checked just now and the repo is a 404. Here are my notes about what…
simonw on HN
PMTiles
From 1 comment
PMTiles is absurdly great software.
simonw on HN
ClickHouse public HN playground
From 1 comment
The query tab looks quite complex with all these content shards: https://hackerbook.dosaygo.com/?view=query I have a much simpler database:…
zX41ZdbW on HN