Tag: N1QL

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

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

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

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

N1QL

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

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.

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)

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

Migrating Data from MongoDB to Couchbase, Part 2

Prolog The previous article provided details on how to migrate a data set from MongoDB to Couchbase. This article will show you how to use the Couchbase SDK to access the data via a Java console application. Code snippets show...

Testing N1QL workloads with Apache JMeter

One of the key features that Couchbase provides for querying JSON data is a N1QL language. N1QL allows users to access and modify the contents of their JSON documents with familiar SQL statements. Quite often, during development phase of a...