Tag: fts

FIRST CLASS SQL for FULL-TEXT SEARCH

Over time, the database industry has realized full-text search and SQL are two sides of the same coin.  Text search needs further query processing, query processing needs text search to efficiently filter for text patterns.   The SQL databases have added...

/ July 7, 2020

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...

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...

Search and Rescue: 7 Reasons for N1QL (SQL) developers to use Search

People don’t want a four key index.  They need a four-ms response. Ted Levitt Application development is demanding. Each application is trying to progress on behalf of the customer — searching for the right product or the right form, ordering,...

/ April 22, 2019

N1QL and SEARCH: How to Leverage Full-Text Index(FTS) in N1QL

The one constant challenge for many application developers with relational databases is the query performance. It is by far the most elusive feature, because the means to resolve the query performance are often limited to what the relational databases can...

/ April 2, 2019

Building a Shazam-like app to understand how Tokenizers and Filters work | FTS Part 2

In the previous blog post, we talked about why full-text search is a better solution at scale to implement a well-designed search in your application. In this second part, we are going to deep-dive on the Inverted Index and explore...

Create a Full Text Search Typeahead with Go, jQuery, and NoSQL

About a week ago I write a tutorial for implementing a typeahead search with Node.js and jQuery. A typeahead is one of many great use-cases when using full text search (FTS), but it certainly isn’t the only use-case. As many...

Tutorial : Using the Query API with a Prebuilt Couchbase Lite 2.0 Database in an iOS App

Couchbase Lite 2.0 is a powerful NoSQL embedded data store for iOS, Android and .Net Mobile Platforms. In an earlier tutorial, we explored the basics of Database and Document CRUD operations using Couchbase Lite within your swift app. In addition...

The Couchbase Data Platform in Action: Couchbase Connect 2017 SV Demo Technical Overview

Last Fall we showed a 30 minute live demo of a full stack application written using a broad range of the Couchbase Data Platform capabilities. This was at the Couchbase Connect Silicon Valley 2017 conference.   In this introductory post,...