alt Hacker NewsI've done something similar with a static hosted site I'm working on. I opted to not reinvent the wheel, and just use WASM Sqlite in the browser. Sqlite already splits the database into fixed-size pages, so the driver using HTTP Range Requests can download only the required pages. Just have to make good indexes.
I can even use Sqlite's full-text search capabilities!
Replies
Aachen • last Wednesday at 2:46 PM
I wonder if you could take this one step further and have opaque queries using homomorphic encryption on the index and then somehow extracting ranges around the document(s) you're interested in
Inspired by: "Show HN: Read Wikipedia privately using homomorphic encryption" https://news.ycombinator.com/item?id=31668814
qcic • last Wednesday at 2:16 PM
Super interesting.
How would that scale to 10TB+ of plain text though? Presumably the indexes would be many gigabytes, especially with full text search.