Category: N1QL / Query

Manage Time-To-Live (TTL) Documents with Couchbase N1QL

There is one feature that I wish had existed with RDBMS, and that is the built-in support for setting a Time-To-Live value for the data records. In NoSQL databases, the support of TTL is very common. NoSQL databases were designed...

/ April 14, 2020

Flexible Query & Indexing for Flexible JSON Model.

Use N1QL when you’re in a JSON pickle. — Confucius For the JSON data model, the advice is to think of collections as tables, JSON document as denormalized rows and field names as columns – roughly. All this holds in...

/ April 13, 2020
N1QL

Index Advisor Service for N1QL (March refresh)

This is our March drop for Index Advisor service for N1QL after fixing some of the bugs that were found after our last refresh in Feb. We plan to keep improvising the Index Advisor service(What is it?). The fixes in...

/ March 31, 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...

Couchbase for Oracle Developers – Part 4 : Data types

Link to the series home page: https://blog.couchbase.com/couchbase-oracle-developers-part-1-overview/ As part of data remodeling, while moving from the relational model to the JSON model, you’ll have to consider the data type mapping. In Oracle, you’ll have to create and declare the types...

/ March 25, 2020
A spreadsheet comparing values of database query capabilities

SQL to NoSQL – 7 Metrics to Compare Query Language

Organizations who want to take advantage of the many benefits of NoSQL document databases, often find that they have two challenges: How to convert their RDBMS schemas to leverage the schema-less document model. Learn a new API/Query  to access the...

/ March 6, 2020
analytics feature

Part 2: N1QL: To Query or To Analyze?

When you need to query documents using SQL, there are two options available in Couchbase. The Query service and the Analytics service. Our blog, N1QL: To Query or To Analyze? provides a detailed overview of both services. I highly recommend...

/ March 4, 2020
RAGE With Couchbase Apollo-GraphQL Featured Image

Fullstack React and GraphQL : Apollo Client

The third of three articles focused on building Fullstack React and GraphQL with the Apollo GraphQL Client. Setting up a NoSQL Couchbase Server (Part 1) Building an Express-GraphQL API (Part 2) Create Apollo GraphQL Client in React (Part 3) Final...

/ February 28, 2020
RAGE With Couchbase Express-GraphQL

Fullstack React and GraphQL : Express Server

The second of three articles focused on building Fullstack React and GraphQL with Express and Couchbase Server. Setting up a NoSQL Couchbase Server (Part 1) Building an Express-GraphQL API (Part 2) Create Apollo GraphQL Client in React (Part 3) Final...

/ February 28, 2020
RAGE With Couchbase Server Featured Image

Fullstack React and GraphQL : Couchbase

First of three articles focused on building Fullstack with React and GraphQL with Express and Couchbase Server. Setting up a NoSQL Couchbase Server (Part 1) Building an Express-GraphQL API (Part 2) Create Apollo GraphQL Client in React (Part 3) Final...

/ February 28, 2020