sql.js-httpvfs | Hosting read-only SQLite databases on static file hosters like Github Pages

sql.js-httpvfs is a TypeScript library. sql.js-httpvfs has no bugs, it has no vulnerabilities, it has a Permissive License and it has medium support. You can download it from GitHub.

See my blog post for an introduction: sql.js is a light wrapper around SQLite compiled with EMScripten for use in the browser (client-side). This repo is a fork of and wrapper around sql.js to provide a read-only HTTP-Range-request based virtual file system for SQLite. It allows hosting an SQLite database on a static file hoster and querying that database from the browser without fully downloading it. The virtual file system is an emscripten filesystem with some "smart" logic to accelerate fetching with virtual read heads that speed up when sequential data is fetched. It could also be useful to other applications, the code is in lazyFile.ts. It might also be useful to implement this lazy fetching as an SQLite VFS since then SQLite could be compiled with e.g. WASI SDK without relying on all the emscripten OS emulation. Note that this whole thing only works well if your database and indexes are structured well. sql.js-httpvfs also provides a proof-of-concept level implementation of a DOM virtual table that allows interacting (read/write) with the browser DOM directly from within SQLite queries.