News for hackers. Stuff that matters.
Re:Hosting SQLite databases on GitHub Pages or any static fi... by ajfjrbfbf on Sunday May 02, 2021 @03:30PM (#27018190)
> sql.js only allows you to create and read from databases that are fully in memory though - so I implemented a virtual file system that fetches chunks of the database with HTTP Range requests when SQLite tries to read from the filesystem: sql.js-httpvfs. From SQLite’s perspective, it just looks like it’s living on a normal computer with an empty filesystem except for a file called /wdi.sqlite3 that it can read from.

From this paragraph it should be pretty clear that it's actually a great result. The database will obviously need to read more data than it presents, so more is fetched.

There are no comments on this comment yet.