News for hackers. Stuff that matters.
Re:A tiny static full-text search engine using Rust and WebA... by pmlnr on Wednesday June 10, 2020 @01:01AM (#23474104)
Push the corpus into SQLite, it has built-in FTS engines[^1]. Then serve it with anything. Unfortunately this needs server side code, but like 30 lines of PHP.

[^1]: https://www.sqlite.org/fts5.html

Re:A tiny static full-text search engine using Rust and WebA... by ComputerGuru on Wednesday June 10, 2020 @01:31AM (#23474276)
You can do SQLite in the browser but it’ll have to download the entire dB file instead of only opening the pages it needs (because the naive JS port can’t convert page requests to range requests).
Re:A tiny static full-text search engine using Rust and WebA... by woadwarrior01 on Wednesday June 10, 2020 @03:08AM (#23474721)
It should be possible to support loading only the required pages on the browser with SQLite compiled to WASM along with a custom VFS implementation. Here’s a project[1] which does something similar (selectively load the SQLite DB on demand), albeit with the SQLite file in a torrent.

[1]: https://github.com/bittorrent/sqltorrent

Re:A tiny static full-text search engine using Rust and WebA... by cluoma on Wednesday June 10, 2020 @03:13AM (#23474736)
Wow this is great, thank you for the tip! My site uses SQLite3 for storage so this is perfect.

I'm continually amazed at how featureful SQLite is.