Tag: SQL

Full Text Search

Introducing Full Text Search (FTS) in Couchbase Mobile 2.0

Couchbase Lite 2.0, now in Developer Preview introduces powerful Full Text Search (FTS) support on your JSON Documents. This is part of the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you...

Database Pagination: Using OFFSET and Keyset in N1QL.

Read the pagination background in my previous article: https://blog.couchbase.com/optimizing-database-pagination-using-couchbase-n1ql/ Pagination is the task of dividing the potential result into pages and retrieving the required pages, one by one on demand.  Using OFFSET and LIMIT is the easy way to write...

/ January 11, 2018
SQL for JSON Query

How to Query Array Collections in Couchbase Lite

One of the major features introduced in Couchbase Lite 2.0 , now in Developer Preview is the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you are familiar with SQL, you will...

Comparing Couchbase Views with Couchbase N1QL & Indexing.

As Couchbase data platform evolved, services like N1QL and GSI Indexing handled the use cases Couchbase VIEWS used to handle and much more.  It’s logical to ask the comparative question between them.  Here is a table comparing both.  This is...

/ December 4, 2017
SQL for JSON Query

Introducing the Query Interface in Couchbase Mobile 2.0

The Couchbase Lite 2.0 Release, now in Developer Preview brings a plethora of new features and enhancements. We discussed one such enhancement, namely the BLIP replication protocol between Couchbase Lite 2.0 and Sync Gateway (v1.5 and above) in an earlier...

Optimizing Database Pagination using Couchbase N1QL.

Background: How does Google do it? When you google something or anything, it gives you back top relevant results, tells you an approximate number of documents for your topic — all under a second.   Here are some high-level pointers: https://www.google.com/search/howsearchworks/algorithms/...

/ November 2, 2017

N1QL: A Practical Guide. Second Edition

Two years and two weeks ago, on a crisp fall day at Wall Street in New York, we launched N1QL in Couchbase 4.0. Even before the launch, we had customers using pre-release N1QL because it solved the critical business problem:...

/ October 26, 2017

Dates, Timestamps and Timezones – A Comparative study of Oracle and N1QL support for the Date-Time feature : Part 1

Read the pdf version here. Date and Time formats/types are very different for different databases. In the article we shall compare Couchbase N1QL Date-Time functions with Oracle’s Date-Time support. Oracle contains multiple data types associated with date-time support, namely, DATE, TIMESTAMP,...

/ September 22, 2017

Learn N1QL in 10 Minutes: An Interactive Online Tutorial

N1QL is SQL for JSON. The goal of N1QL is to give developers and enterprises an expressive, powerful, and complete language for querying, transforming, and manipulating JSON data. The goal of N1QL is to give developers and enterprises an expressive,...

/ September 7, 2017
Aggregate grouping - licensed through Creative Commons https://commons.wikimedia.org/wiki/File:Spices_of_Sa%C3%BAde_flea_market,_S%C3%A3o_Paulo,_Brazil.jpg

Aggregate grouping with N1QL or with MapReduce

Aggregate grouping is what I’m titling this blog post, but I don’t know if it’s the best name. Have you ever used MySQL’s GROUP_CONCAT function or the FOR XML PATH('') workaround in SQL Server? That’s basically what I’m writing about...