sql.js-httpvfs

GitHub describes it as Hosting read-only SQLite databases on static file hosters like Github Pages. The repository metadata lists TypeScript as its primary language. The metadata lists the Apache-2.0 license. This article stays within the project description and details documented in the GitHub repository README.

GitHub describes it as Hosting read-only SQLite databases on static file hosters like Github Pages. The repository metadata lists TypeScript as its primary language. The metadata lists the Apache-2.0 license. The README describes the project this way: See my blog post for an introduction: https://phiresky.github.io/blog/2021/hosting-sqlite-databases-on-github-pages/

The README section "sql.js-httpvfs" states: sql.js is a light wrapper around SQLite compiled with EMScripten for use in the browser (client-side).

The README section "sql.js-httpvfs" states: 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 README section "sql.js-httpvfs" states: 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.

The repository README is the source for this review. It does not replace a local installation or an independent test.

• Source 1 · Project repository
• Source 2 · README