Full Text Indexing and Search in CockroachDB

In this post, Michael Goddard explores full text indexing and search using CockroachDB. He begins by discussing the motivation behind his experiment and then presents an initial solution for implementing a text search feature with CockroachDB. The solution involves creating two tables, indexing certain columns within these tables, and running SQL queries to find rows containing specific terms. Goddard also discusses limitations of this simplistic approach, such as the absence of ranking mechanisms and phrase queries. He concludes by highlighting the benefits of using Elasticsearch or Solr for text search and expressing his interest in further experimentation with CockroachDB's capabilities.