3 ms·
I wonder how effective this would be with the SQLite with a new virtual file system fetching pages via XHR that someone posted last month. Then you would be abl
by lsb 5y ago
I wonder how effective this would be with the SQLite with a new virtual file system fetching pages via XHR that someone posted last month. Then you would be able to do full text search on a huge database only sending a few KB per search
https://news.ycombinator.com/item?id=27016630 https://news.ycombinator.com/item?id=27016630
- deleted 5y ago[deleted]
- gregsadetsky 5y agoI’ve been a bit obsessed with that post since it came out as well. Would it be conceivable to replace Algolia in this way for static data sets (i.e. those that don’t need the write/update API)?
- justsomeuser 5y agoI guess it would be quite slow because of the network latency.
- SahAssar 5y agoI tried it (FTS5 on sql.js-httpvfs) with a 600mb FTS table containing OSM data. It works but the queries are quite a bit slower and there is quite a large difference between browsers. Some queries that took 1s in chrome took 10s in FF although I'm not sure why yet.