/plushcap/analysis/cockroach-labs/full-text-indexing-and-search-in-cockroachdb

Full Text Indexing and Search in CockroachDB

What's this blog post about?

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.

Company
Cockroach Labs

Date published
Aug. 27, 2020

Author(s)
Michael Goddard

Word count
1359

Language
English

Hacker News points
2


By Matt Makai. 2021-2024.