Category: SQL++ / N1QL Query

Create the Right Index, Get the Right Performance.

Create the Right Index, Get the Right Performance.

Introduction There are three things important in database systems: performance, performance, performance. For NoSQL database systems, there are three important things: performance at scale, performance at scale, performance at scale. Understanding the index options, creating the right index, with the...

Keshav Murthy November 12, 2017
Tooling Improvements in Couchbase Server 5.0 (Update)

Tooling Improvements in Couchbase Server 5.0 (Update)

Tooling improvements have come to Couchbase Server 5.0. Note: this is an updated repost of Tooling Improvements in Couchbase 5.0 Beta. In this blog post, I’m going to show you some of the tooling improvements in: Query plan visualization –...

Matthew Groves November 8, 2017
Profiling and Monitoring in Couchbase Server 5.0 Preview (Update)

Profiling and Monitoring in Couchbase Server 5.0 Preview (Update)

Profiling and monitoring for N1QL are a big part of the Couchbase Server 5.0 release (now available for download). Note: this is an updated repost of Profiling and Monitoring in Couchbase Server 5.0 Preview (Update). Query Workbench Once again, I’ll...

Matthew Groves November 7, 2017
Optimizing Database Pagination using Couchbase N1QL.

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

Keshav Murthy November 2, 2017
N1QL Enhancements in Couchbase Server 5.0

N1QL Enhancements in Couchbase Server 5.0

N1QL enhancements have come to Couchbase. N1QL is one of the flagship features of Couchbase Server. The release of Couchbase Server 5.0 further bolsters N1QL with a range of enhancements. Many of these enhancements have been covered in previous blog...

Matthew Groves October 31, 2017
Announcing Couchbase Server 5.0

Announcing Couchbase Server 5.0

Couchbase Server 5.0 is here!!! I am thrilled to announce the availability of this major release. Couchbase Server 5.0 is the latest release of the most powerful NoSQL technology. Couchbase Server, the foundation of the Couchbase Data Platform, allows enterprises...

Using Role-Based Access Control in N1QL

Using Role-Based Access Control in N1QL

In Couchbase 4.5, data was secured bucket by bucket. Each bucket had a password, and in order to access a bucket through a N1QL query, the user had to include the bucket password with the query. Passwordless buckets were possible,...

Johan Larson October 23, 2017
Optimize N1QL performance using request profiling

Optimize N1QL performance using request profiling

Monitoring uncovered the resource hog. Now what? Couchbase Server 4.5 introduced a mechanism to keep an eye on executing requests, so that slow performers could be highlighted. This DZone article covers the subject of N1QL monitoring in great detail, but...

CURL Comes to N1QL: Querying External JSON Data

CURL Comes to N1QL: Querying External JSON Data

JSON is a helpful way to transmit data. Now, N1QL can query it thanks to a CURL update in Couchbase 5.0. See how to connect to various endpoints to do just that. N1QL has many functions that allow you to...

Isha Kandaswamy October 6, 2017
Oracle Date Format: N1QL and Support for Date-Time Functions

Oracle Date Format: N1QL and Support for Date-Time Functions

Date and Time functions and formats can vary for different databases. In this article, we shall compare Couchbase ISO-based Date-Time functions with Oracle Date format. Date formats vary between relational and NoSQL database due to the nature of NoSQL JSON...

Couchbase Product Marketing September 22, 2017
Blazing Fast Index Performance with Plasma

Blazing Fast Index Performance with Plasma

In the earlier post, we got an opportunity to introduce Plasma as the new performant storage engine that powers Global Secondary Indexes in Couchbase 5.0(beta out!). We saw some of the features of Plasma and how it is designed with...

Gear up with N1QL to the era of Engagement Databases

Gear up with N1QL to the era of Engagement Databases

Couchbase Engagement Database Platform Woo-Hoo!!! Have you heard of Engagement Databases? I am sure, “No”, not until Couchbase announced it with 5.0 release. In today’s digital economy, success of a business is dependent on its ability to leverage successful digital...