News for hackers. Stuff that matters.

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

Re:Hosting SQLite databases on GitHub Pages or any static fi... by ianlevesque on Sunday May 02, 2021 @02:19PM (#27017497)
This is easily the most clever web programming hack I’ve seen this year. Bravo. I had seen this used for video or audio of course but it never occurred to me you could use it for databases. There are probably a ton of other formats this is good for too.
[ Parent | on HN ]
Re:Hosting SQLite databases on GitHub Pages or any static fi... by Valgrim on Sunday May 02, 2021 @08:25PM (#27020372)
I wonder if this could be used to serve dynamic maps.
[ Parent | on HN ]
Re:Hosting SQLite databases on GitHub Pages or any static fi... by blacha on Sunday May 02, 2021 @11:48PM (#27021429)
This is pretty much exactly what we do to serve aerial/satellite imagery maps.

We convert the imagery into Cloud optimised geo tiffs and store them in S3 https://www.cogeo.org/ then the browser can request the tiles directly from S3.

Even the big imagery providers are now storing their imagery as COGs, eg https://registry.opendata.aws/sentinel-2-l2a-cogs/

[ Parent | on HN ]
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 ]