sql.js icon indicating copy to clipboard operation
sql.js copied to clipboard

Add support for opening URLs (lazy database file)

Open boramalper opened this issue 5 years ago • 1 comments

I've added support for opening URLs using FS.createLazyFile API of Emscripten. I've modified api.coffee and worker.coffee respectively.

It might be also useful to document somewhere (README or the API docs?) that the following headers must be present for the file to be lazy-loaded (see library_fs.js:1703):

  1. Accept-Ranges: bytes
  2. Content-Length
  3. Content-Encoding (if other than identity)

Care must be taken that these headers are accessible from XHR requests, thus appropriate CORS headers (e.g. Access-Control-Expose-Headers) must be set accordingly.

boramalper avatar Jun 02 '19 21:06 boramalper

See https://boramalper.github.io/client-side-sqlite/ for a demo.

boramalper avatar Jun 12 '19 12:06 boramalper