3 ms·
This is really neat. It looks like it's using a similar trick to https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/ https://phiresky
by simonw 4y ago
This is really neat. It looks like it's using a similar trick to https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/ https://phiresky.github.io/blog/2021/hosting-sqlite-database... from last year - querying SQLite databases hosted as static files using the HTTP range header to fetch back just the pages from the database file that are needed by a specific query.
- chrsig 4y agoi wish s3 supported multiple ranges in the range header. I've done this sort of access with a custom columnar format that stored a set of columns in a single file it was a non-trivial overhead to have to send an http request per column, when i could have sent one with multiple ranges. i can imagine something similar with this, fetching multiple pages in one request
- mbo 4y ago[Shameless plug] I built a very minimal wrapper to get this working for the Observable web data visualisation environment https://observablehq.com/@mjbo/sqljs-httpvfs https://observablehq.com/@mjbo/sqljs-httpvfs