Exploring Full Text Search Implementation with Exmeralda

The post details the challenges faced during the launch of Exmeralda when a simple coding error in the full-text search implementation led to unexpected search results. Initially, the search combined full-text and semantic searches, but a lack of evaluation revealed that typical search phrases returned no matches due to the use of an AND operator in the search functionality. The author explains the various adjustments made to the search queries, such as the introduction of 'english' options in the queries and the use of PostgreSQL's `ts_rank` for better results. The post also discusses the implementation of the `pg_trgm` extension for partial matches and the necessity of using semantic search models for improved accuracy. The article concludes with insights into testing and enhancing the full-text search capabilities of the Exmeralda library.