Category: SQL++ / N1QL Query

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

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

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

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

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

February 20, 2017
Announcing Couchbase Server 4.6 – What’s New and Improved

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

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

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

February 14, 2017
Couchbase Developer Release – Put some cURL in your N1QL

Couchbase Developer Release – Put some cURL in your N1QL

What is cURL? Ever heard of cURL? It’s a famous command line tool for sending/receiving data using URL syntax, says wikipedia here. Let’s start with an example related to Couchbase. The N1QL query service is available through a REST API....

Moving from SQL Server to Couchbase Part 1: Data Modeling

Moving from SQL Server to Couchbase Part 1: Data Modeling

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

February 3, 2017
Analyze Donald Trump Tweets with Couchbase and N1QL

Analyze Donald Trump Tweets with Couchbase and N1QL

AWS Serverless Lambda Scheduled Events to Store Tweets in Couchbase explained how to store tweets in Couchbase using AWS Serverless Lambda. Now, this Lambda Function has been running for a few days and has collected 269 tweets from @realDonaldTrump. This blog ,...

Using N1QL Subquery Expressions to Query Over Nested Couchbase Documents

Using N1QL Subquery Expressions to Query Over Nested Couchbase Documents

Back in Couchbase 4.0, N1QL was introduced as a way to give developers more flexibility when querying their NoSQL data stored within Couchbase Server. You could run SQL queries against JSON data and everything would be amazing. However, with N1QL...

Video Tutorial for Creating a URL Shortener with Node.js and N1QL

Video Tutorial for Creating a URL Shortener with Node.js and N1QL

Not too long ago I wrote a lengthy tutorial on how to use Node.js and Couchbase to create a URL shortener.  This tutorial used N1QL for querying the data.  To compliment that writeup I’ve gone ahead and created a video...