Tag: N1QL
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
Paging Data Queries with N1QL
M. David Allen is a full-stack software engineer and entrepreneur who for more than a decade has been working with just about every different programming language and different type of database system he could get his hands on. David has...
Laura Czajkowski, Developer Community Manager, Couchbase
August 25, 2017
Aggregate grouping with N1QL / MapReduce
Aggregate grouping is what I’m titling this blog post, but I don’t know if it’s the best name. Have you ever used MySQL’s GROUP_CONCAT function or the FOR XML PATH('') workaround in SQL Server? That’s basically what I’m writing about...
Matthew Groves
August 22, 2017
Diving into Couchbase Index Replicas
With Couchbase Server 4.x, customers used to create Equivalent Indexes to satisfy the twin requirements of keeping the indexes highly available and to load balance the N1QL queries. What this meant was that the exact same index definition was used...
Venkat Subramanian, Product Manager
August 14, 2017
Bringing SQL to NoSQL – Rich, Declarative Querying for JSON
Couchbase Server is a document-oriented NoSQL database. Most NoSQL systems force you to sacrifice the rich querying capabilities of SQL in trade for the other benefits they offer. At Couchbase, we’ve developed the N1QL query language to solve this problem....
Hod Greeley, Developer Advocate, Couchbase
July 5, 2017
Tooling Improvements in Couchbase 5.0 Beta
Tooling improvements have come to Couchbase Server 5.0 Beta. In this blog post, I’m going to show you some of the tooling improvements in: Query plan visualization – to better understand how a query is going to execute Query monitoring...
Matthew Groves
June 7, 2017