News for hackers. Stuff that matters.
Re:Hosting SQLite databases on GitHub Pages or any static fi... by Salgat on Monday May 03, 2021 @02:31AM (#27022254)
Use Http Range (normally used for pausing and continuing large file downloads) to request specific byte ranges from the file. From there you can pull only what you need. With sql indexes it'll be very tiny since the lookup is optimized. Of course if you select *, you're still going to pull the entire database locally.

There are no comments on this comment yet.