Cloud Backed SQLite
I've just been exploring serving large SQLite databases in chunks and querying them with http range requests to prevent downloading the entire database. It's pretty awesome!<p>I found a really interesting library called sql.js-httpvfs[0] that does pretty much all the work. I chunked up my 350Mb sqlite db into 43 x 8Mb pieces with the included script and uploaded them with my static files to GitHub, which gets deployed via GitHub Pages.[1]<p>It's in the very rough early stages but you can check it out here.<p><a href="https://transcript.fish" rel="nofollow noreferrer">https://transcript.fish</a><p>I recommend going into the console and network tab to see it in action. It's impressively quick and I haven't even fine-tuned it at all yet. SQLite rules.<p>[0] <a href="https://github.com/phiresky/sql.js-httpvfs">https://github.com/phiresky/sql.js-httpvfs</a><p>[1] <a href="https://github.com/noman-land/transcript.fish">https://github.com/noman-land/transcript.fish</a>