Category: Full Text Search

FTS and N1QL: Improving Performance when Querying Multiple Arrays

Introduction Couchbase Full Text Search (FTS) is a great fit for indexing multiple arrays and executing queries with multiple filter predicates in arrays.  In this article, I’ll demonstrate the advantages of using FTS over GSI (Global Secondary Index) for array...

Announcing Couchbase Server 6.5 GA – What’s New and Improved

We are pleased to announce the release of Couchbase Server 6.5 GA with stellar features that lead the innovation in the NoSQL database market. We are excited to once again pioneer some of the most sought-after relational capabilities in the...

Map - public domain via https://www.flickr.com/photos/130729854@N07/16491939584

Introducing Geo Bounded Polygon Query in Full Text Search

Geo Bounded Polygon Query   The ability to perform text search with geo capabilities is a very powerful and effective feature from full text search(FTS). And we are bringing the more flexible geo bounded polygon query feature to FTS in...

/ January 16, 2020

Full Text Search Indexing Best Practices by Use Case

Introduction Full text search (FTS) indexing can be challenging for those who are not familiar with search in general.  In this post, we’ll take some common search use cases and work through the creation of appropriate indexes following best practices...

Introducing FTS with N1QL

Topics this article will cover What’s good with N1QL? What about FTS? But why FTS within N1QL? Basic N1QL+FTS queries Deploying N1QL+FTS Syntax(es) Abilities & limitations N1QL+FTS Internals Covered-index vs Non-covered-index queries More N1QL+FTS query examples What’s next? 1. Couchbase’s...

Couchbase mobile 2.6

Few Index Management Tips – FTS Best Practices Part II

We have already seen a handful of best practices for defining an FTS index in part1, now let’s explore a few useful tips about the operational and maintenance aspects of an index.   A user who is new to the...

/ September 23, 2019

Running FTS Queries in N1QL

We already discussed how the Like % clause is potentially harmful for your application at scale, and why you should consider using Couchbase Full-Text Search instead. One thing we haven’t mentioned yet is why you might prefer Couchbase FTS over any...

Customer 360 – Part 4 – Analyzing Your Data

OK, so we’ve looked at building aspects of a Customer 360 solution in previous posts. We looked at an overview of what’s involved in part 1, and since you’re reading this, I’m assuming that the threat of having to think...

/ August 13, 2019

Building autoComplete or typeAhead functionality using Full Text Search

  What is autoComplete? Autocomplete as the wikipedia says “Autocomplete, or word completion, is a feature in which an application predicts the rest of a word a user is typing” It is also known as  Suggestions or Type Ahead or...

/ August 6, 2019

FTS Performance Improvements in 6.5.0 – Part 2

  For all those who are restlessly eager, let me reveal the deep dark secret of all the performance optimisations in FTS in 6.5.0 is, “ Do less And Do it less often **  ” And I am sure you...

/ July 11, 2019