News for hackers. Stuff that matters.

A comment on Hosting SQLite databases on GitHub Pages or any static file hoster. Parent comment

Re:Hosting SQLite databases on GitHub Pages or any static fi... by durkie on Sunday May 02, 2021 @10:27PM (#27021018)
I believe this is protomaps approach: re-encode the mbtiles (sqlite-based ) format in to something that can be requested with a http range request and thus served from a single dumb webserver that doesn't need to understand sqlite or mbtiles parsing
[ Parent | on HN ]
Re:Hosting SQLite databases on GitHub Pages or any static fi... by bdon on Sunday May 02, 2021 @11:49PM (#27021431)
This is the approach I took with http://github.com/protomaps/pmtiles , though it's optimized for the very specific use case of going from Z/X/Y integer coordinates to binary blobs, and takes shortcuts to accomplish that (fixed-width keys and root index page)
[ Parent | on HN ]
Re:Hosting SQLite databases on GitHub Pages or any static fi... by config_yml on Monday May 03, 2021 @02:36AM (#27022279)
Funny enough I was looking into mbtiles serverless solutions before I went to bed, now I start my day browsing HN and I find this clever solution. Love HN for this type of stuff :)
[ Parent | on HN ]