sqlite-wasm-http: An experimental HTTP VFS driver for SQLite WASM
7 points by romforth
7 points by romforth
Cool experiment, but I think performance would be pretty poor since it has to read the database with a whole bunch of sequential 4KB HTTP GETs, which can’t be batched or pipelined because the API is synchronous.
It's not great but it's definitely usable for a lot of applications. I'm using the older sql.js-httpvfs to make IRC/Matrix logs searchable on a static host, and, yes, it does a second or so to make the 40 sequential 2-4KB GETs necessary to load the first page of results, but it's still nicer than downloading the whole 200MB database. Plus it caches the parts it's already loaded in memory so subsequent operations are faster.