Category: SQL++ / N1QL Query

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

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

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

Migrate From MongoDB to Couchbase with N1QL
Customers often tell us they’re preparing to migrate from MongoDB to Couchbase. They come, in part, because they’re tired of the problems they’ve experienced learning how to query MongoDB. Couchbase with N1QL provides a better alternative, especially for scaling up...

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

Joining NoSQL Data: MongoDB Query Language vs Couchbase N1QL
One of the most frequent questions I receive when it comes to NoSQL is on the subject of joining data from multiple documents into a single query result. While this question is brought up more frequently from RDBMS developers, I...

New Profiling and Monitoring in Couchbase Server 5.0 Preview
N1QL query monitoring and profiling updates are just some of goodness you can find in February’s developer preview release of Couchbase Server 5.0.0. Go download the February 5.0.0 developer release of Couchbase Server today, click the “Developer” tab, and check...

Announcing Couchbase Server 4.6 – What’s New and Improved
Couchbase delivers the Couchbase Data Platform that powers Web, Mobile, and IoT applications for digital businesses. With our newest release, Couchbase Server 4.6 provides the availability, scalability, performance, and security that enterprises require for their mission-critical applications. What’s New and...

Using Couchbase JDBC with Tibco BusinessWorks
Couchbase JDBC and Tibco ActiveMatrix Business Works 6.3 Summary Establish rapid application workflows with Tibco ActiveMatrix Business Works by using Couchbase Server third-party drivers provided by SimbaTechnologies and CData. Table of Contents Third Party Tools Query Data Integration Tibco Business Works Setup...

Moving from SQL Server to Couchbase Part 2: Data 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 compared to Couchbase Server. In three parts, I’m going to...