Category: SQL++ / N1QL Query

Music City Code Workshop on Full Stack JavaScript Development Available

Music City Code Workshop on Full Stack JavaScript Development Available

This past week I was in Nashville, Tennessee attending the Music City Code conference. It was a very interesting conference and my first experience in Nashville as I’m a California native. At Music City Code I gave a workshop titled, Full...

Tooling Improvements in Couchbase 5.0 Beta

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
The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker

The Fastest Way to Identify PII Stored in your Database: A Simple Example Using N1QL, Nodejs and Docker

A frequent request from customers is a way to identify PII within their databases.   I thought I’d show a brief example how this can be done. User Story: “I want to identify unencrypted credit card numbers and social security numbers...

Todd Greenstein June 1, 2017
Sample Application with Spring and Angular: GitTalent

Sample Application with Spring and Angular: GitTalent

One of the first big projects I was involved in after I started at Couchbase last year was helping to create a sample application that would be demonstrated at Couchbase Connect. Sample application It was an enormous team effort to...

Matthew Groves May 3, 2017
New to Couchbase Server 5.0: GSI replicas and rebalancing

New to Couchbase Server 5.0: GSI replicas and rebalancing

Couchbase Server 4.0 introduced Global Secondary Indexes (GSI) to support the N1QL query engine.  Now, with Couchbase Server 5.0 (as of the April developer build), we have added the ability to automatically replicate and rebalance these indexes. At first, GSIs...

Perry Krug April 30, 2017
Perform Various N1QL Queries without Indexes in Couchbase Server

Perform Various N1QL Queries without Indexes in Couchbase Server

As you probably already know, you’re able to query Couchbase NoSQL documents using a SQL dialect called N1QL.  This is made possible through indexes that you create on documents in your Couchbase Buckets.  However, what if I told you that...

Document-Oriented Database and N1QL

Document-Oriented Database and N1QL

Michael  K. Aboagye works as an application security engineer and web pentester with good knowledge in Linux, Git, PHP, Java, RDMS and Nosql database development. He likes to dabble in devops also. Document-Oriented Database and N1QL For this article, I will share...

Performance Enhancements to N1QL in the Couchbase 5.0 March Developer Build

Performance Enhancements to N1QL in the Couchbase 5.0 March Developer Build

N1QL in Couchbase has come a long way since it was first introduced in Couchbase Server 4.0.  In Couchbase 5.0, things are taken to the next level in terms of performance.  In terms of the March 2017 Developer build of Couchbase...

ANN: Couchbase Lite Developer Build 003 (Obj C, Swift, .NET)

ANN: Couchbase Lite Developer Build 003 (Obj C, Swift, .NET)

I am very pleased that Couchbase Lite Developer Build 003 is now available for download for Objective C, Swift and “.NET”. Database queries have changed significantly in this release. Couchbase Lite 2.0 uses semantics based on N1QL query language defined...

Working with Arrays in Couchbase with N1QL – Video Tutorial

Working with Arrays in Couchbase with N1QL – Video Tutorial

In a recent article, I wrote about flattening and querying arrays in Couchbase using N1QL.  That article was inspired by a popular question in the Couchbase Forums.  After publishing the article, I felt a write-up alone couldn’t do it justice...

N1QL: A Practical Guide

N1QL: A Practical Guide

N1QL is designed to help developers easily develop applications to solve real-world problems.  Technically, N1QL is designed to give developers and enterprises an expressive, powerful, and complete language for querying, transforming, and manipulating JSON data. N1QL takes inspiration from SQL...

Keshav Murthy March 17, 2017
Feature Enhancements to N1QL in the Couchbase Server 5.0 March Developer Build

Feature Enhancements to N1QL in the Couchbase Server 5.0 March Developer Build

With the recent March 2017 Developer build of Couchbase there were many bug fixes, but also feature enhancements to core technologies like N1QL.  For example, now indexes can be created on various meta information such as the document cas and...