sql.js-httpvfs

They left the sourcemaps in their build, so one can see the code from the Usage section of sql.js-httpvfs (https://github.com/phiresky/sql.js-httpvfs#usage) copy-pasted into App.tsx, but I didn't find any other identifying text I'd actually guess it was just a copy-paste of the "sqlite over webworker using wasm" demo, backed by the actual sqlite of the actions https://www.awsiam.info/iam.db

Looks pretty similar to https://github.com/phiresky/sql.js-httpvfs My first instinct is to wonder why not giving them credit, but maybe you’d never heard of it before…

Looks like Netlify changed something since I wrote this article regarding what headers they send. Detecting support for Range-requests is kinda tricky and relies on heuristics [1]. Not sure why it still works in Chrome though. You can go to this version of my blog, it should work there: https://phiresky.github.io/blog/2021/hosting-sqlite-database... Maybe the link could be updated? Except for the DOM demo, since those need some Cross-Site-Isolation Headers you can't set on GitHub Pages (that's the reason I mirrored it to Netlify originally) [1] https://github.com/phiresky/sql.js-httpvfs/issues/13

Yeaah I felt like at that point the article was already long enough so I didn't bother describing the DOM part too much - even though I spent more time implementing that than I did implementing the rest ;) Basically SQLite has a virtual table mechanism [1] where you have to define a few functions that figure out how to scan your "fake" table / which indices to use and then how to read / write the actual data. I hook into this mechanism and redirect the request to DOM functions like querySelector() etc. Then there's the issue about SQLite being fully synchronous, but I have to run it in a WebWorker - and the WebWorker can't actually access the DOM and it can only communicate asynchronously with the main thread... So I have to do some weird stuff with SharedArrayBuffer and Atomics.wait to make that work [2]. [1] https://www.sqlite.org/vtab.

The question I had is answered by this line of code: xhr.setRequestHeader("Range", "bytes=" + from + "-" + to); I am a little surprised you can just do that. In https://github.com/phiresky/sql.js-httpvfs/blob/master/src/l...