Category: SQL++ / N1QL Query

SQL to NoSQL – 7 Metrics to Compare Query Language

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
Part 2: N1QL: To Query or To Analyze?

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
Fullstack React and GraphQL : Apollo Client

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
Fullstack React and GraphQL : Express Server

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
Fullstack React and GraphQL : Couchbase

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
IN List Handling Improvements in Couchbase Server 6.5

IN List Handling Improvements in Couchbase Server 6.5

Introduction IN list is commonly used in N1QL queries. Couchbase Server 6.5 introduces a couple of enhancements in handling of IN list in N1QL queries. Handling of Large IN List Before Couchbase Server 6.5 N1QL handles IN list evaluation at...

Index Advisor Service for Couchbase N1QL(Feb refresh)

Index Advisor Service for Couchbase N1QL(Feb refresh)

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

February 12, 2020
Announcing Couchbase Server 6.5 GA – What’s New and Improved

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

ANSI JOIN Enhancements and  ANSI MERGE

ANSI JOIN Enhancements and ANSI MERGE

Introduction N1QL support for ANSI JOIN was first introduced in version 5.5. Currently there is a restriction in ANSI JOIN (version 5.5 and 6.0) in that the right-hand side of an ANSI JOIN must be a keyspace. This restriction will...

Couchbase 6.5 – RMS for Indexing Service

Couchbase 6.5 – RMS for Indexing Service

Couchbase 6.5 release includes an extensive list of Enterprise Grade Database Query capability that allows customers to expand the adoption of NoSQL database into traditional database applications. The release has added transactional capability, Analytical Window functions, user defined JS functions,...

January 20, 2020
Simple dataviz with N1QL and Google Sheets.

Simple dataviz with N1QL and Google Sheets.

Do whatever it takes to present the data to aid analysis and thinking.  — Edward Tufte How do you create graphs like these if you don’t already have some ready-made cool dataviz tool? You can run queries to wrangle the...

January 7, 2020
Index Advisor Service for Couchbase N1QL(SQL for JSON)

Index Advisor Service for Couchbase N1QL(SQL for JSON)

We are excited to announce the release of : Couchbase Index Advisor Service http://index-advisor.couchbase.com Yet Another service? Why? We released N1QL(SQL for JSON) a few years ago- so that you could use SQL to retrieve and manipulate JSON data. But...

December 26, 2019