Category: N1QL / Query

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)

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

/ March 24, 2017

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

/ March 17, 2017

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

Monitoring and profiling

Profiling and Monitoring in Couchbase Server 5.0 Preview (Update)

In March’s developer build, there are some more updates for N1QL query monitoring and profiling. Go download the March 5.0.0 developer release of Couchbase Server today. Make sure to click the “Developer” tab to get the developer build (DB), and...

Moving Your Node.js with MongoDB Application to Couchbase with N1QL

If you’ve been keeping up with my recent blog articles, you’ll know that I’ve been focusing on the topic of moving applications from MongoDB to Couchbase.  NoSQL is great in modern web applications, but not all NoSQL is created equal...

Geese migration licensed through Creative Commons https://commons.wikimedia.org/wiki/File:BrantaLeucopsisMigration.jpg

Moving from SQL Server to Couchbase Part 3: App Migration

Moving from SQL Server to Couchbase Part 3: App Migration In this series of blog posts, I’m going to lay out the considerations when moving to a document database when you have a relational background. Specifically, Microsoft SQL Server as...

Workshop Content for Full-Stack Java and NoSQL Development Now Available

About a week ago I was at DevNexus 2017 in Atlanta, Georgia, giving a workshop on creating full stack applications using a variety of technologies such as Java, Angular, Docker, Couchbase, and JavaFX. Everyone who participated in the full day...

Flattening and Querying NoSQL Array Data with Couchbase N1QL

I was browsing the Couchbase forums and I came across a question regarding queries against array data in Couchbase.  Coming from a relational database, I too once struggled to grasp the concept of querying complex formatted JSON data with SQL....