Hosting SQLite databases on GitHub Pages or any static file hoster
Report a link problem
Submission timeline
2007–2026One slot for every year since HN launched. Height is that year's peak points; orange marks a 100+ point or 50+ comment breakout. Select a bar to open its strongest thread.
First comments on top threads
HN comment orderPop open the network pane in the browser tools and try running this SQL query for a demo of how clever this is: select country_code, long_name from wdi_country order by rowid desc limit 100 It fetches just 54.2KB of new data (across 49 small HTTP requests) to return 100 results - from a statically hosted database file that's 668.8MB! I have an animated GIF demo of this here: https://twitter.com/simonw/status/1388933800445452290
A point of great pain for me in the use of HTTP range headers is that they are absolutely incompatible with HTTP compression. This boils down to an ambiguity found in the early days of HTTP: when you ask for a byte range with compression enabled, are you referring to a range in the uncompressed or compressed stream? The only reasonable answer, in my opinion: a range of bytes in the uncompressed version, which is then compressed on-the-fly to save…
It would be a it more compelling if every example, at least for me, didn't return `[error: NetworkError: A network error occurred.]`
The first top-level comment from each of the four biggest threads, in HN’s own order. Excerpts are shortened; open a comment for full context.
- Breakout years
- 2
- Total points
- 2103
- Total comments
- 314
100+ points or 50+ comments
reference only — not used in Hall rules or ranking
reference only — not used in Hall rules or ranking
Every submission
| Date | Title as submitted | By | Points | Comments |
|---|---|---|---|---|
| 2021-05-02 | Hosting SQLite databases on GitHub Pages or any static file hosterFirst breakout · Best thread | phiresky | 1812 | 244 |
| 2022-10-12 | Hosting SQLite databases on any static file hoster (2021) | punnerud | 199 | 51 |
| 2024-07-14 | Hosting SQLite databases on GitHub Pages (or any static file hoster) (2021) | fanf2 | 2 | 0 |
| 2025-05-20 | Hosting SQLite databases on GitHub Pages – (or IPFS or any static file hoster) (2021) | thunderbong | 2 | 0 |
| 2025-09-05 | Hosting SQLite databases on GitHub Pages (2021) | whatisabcdefgh | 2 | 0 |
| 2025-10-29 | Hosting SQLite Databases on GitHub Pages (2021)Latest 20+ point return | WA9ACE | 86 | 19 |