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: Better Performance 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 & Rescue: 7 Reasons N1QL (SQL) developers 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 & SEARCH: Leverage Full-Text Search (FTS) Index in N1QL

With Couchbase v6.5, Full-Text Search is now integrated into the Couchbase N1QL query construct. Customers can now leverage FTS indexes directly with N1QL. This provides developers a single API to combine N1QL exact predicate matching and FTS powerful searching. The...

/ December 11, 2018

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

A mockup of a mobile search engine for universities with Ann Arbor as the entered criteria

Tutorial: Using the Query API With Couchbase Lite, iOS

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 iOS Swift app. In...

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