phiresky/sql.js-httpvfs

There is also the deep magic... https://github.com/phiresky/sql.js-httpvfs

if performance becomes a problem statically hosting sqlite DBs with client side queries and http range requests is an interesting approach: https://github.com/phiresky/sql.js-httpvfs

…atic-shards/shard_1636.sqlite.gz https://hackerbook.dosaygo.com/static-shards/shard_1635.sqlite.gz https://hackerbook.dosaygo.com/static-shards/shard_1634.sqlite.gz As I paginated to previous days. It's reminiscent of that brilliant SQLite.js VFS trick from a few years ago: https://github.com/phiresky/sql.js-httpvfs - only that one used HTTP range headers, this one uses sharded files instead. The interactive SQL query interface at https://hackerbook.dosaygo.com/?view=query asks you to select which shards to run the query against, there are 1636 total.

correct! it's a sqlite database which ends up being automatically gzip'd by the github cdn aka fastly - this ends up being ~4mb over the wire obviously this solution doesn't scale (versus something like https://github.com/phiresky/sql.js-httpvfs ) but sometimes it's fun to "just" send the sqlite database to the frontend and be done :-)