Category: SQL++ / N1QL Query
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.
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 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
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
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
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...
Marco Greco, Software Architect, Couchbase
October 20, 2017
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
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
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...
Venkat Subramanian, Product Manager
September 22, 2017
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...
Prasad Varakur, Principal Product Manager, Couchbase
September 21, 2017
Pagination in Couchbase Server with N1QL and PHP
Onwuka Gideon is a freelance full stack developer with years of experience designing and coding web applications and solving complex problems. He loves security, writing, and discussing new technology. When building applications that deal with a large number of documents,...
Laura Czajkowski, Developer Community Manager, Couchbase
September 13, 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,...
Keshav Murthy
September 7, 2017