Full Text Search in DataFrames
SQL Frames supports searching data using text. It is possible to search for multiple words and use boolean operators like AND and OR. But it is much more powerful than that. It supports the following
- Text search operator can be combined with other filter conditions in the WHERE clause.
- It is possible to do text search on only a subset of the fields.
- It is even possible to do text search on multiple tables when joining them.
There are several text search engines available each with different characteristics. For example, some are extremely fast to index while some have better relevance. Lunr was selected primarily for its better user experience of constructing the search query.
The text search framework is built such that it can be replaced with other search engines. In the future it may allow configuring which search framework to use.