Hacker News new | ask | show | jobs
by FridgeSeal 1424 days ago
Looks promising, keen to try it out.

Related question though: why do so many FTS offerings in the space also try and offer column/analytics features? In my experience, I've already got a database for that, I'd really just love to see a FTS engine that _just_ searches text and filters responses, as fast and accurately as possible. Leave the analytics to my column database, just search the text as fast as possible.

1 comments

It's a very good question. The answer is that when people do data analytics they often also need full-text search, otherwise it may just be too slow to scan through all your terabytes of strings using LIKE or REGEXP. You need some indexes to make it faster. Indexes for strings is what's partly full-text search is.

That's why Clickhouse can be integrated with Quickwit, for example.

Manticore aims to be a good full-text search engine + can process large data volume that doesn't fit into RAM with help of the columnar storage.