Category: SQL++ / N1QL Query

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

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

Couchbase and the Document-Oriented NoSQL Database
As a developer advocate at Couchbase, I often travel around and meet people who either have no idea what NoSQL is, or more importantly what Couchbase is. For the people who are already familiar with NoSQL, Couchbase often gets compared...

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

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

Taxi Ride Analysis – Native Analytics on Couchbase with Cloud9 Charts
This is a guest post by Jay Gopalakrishnan. Jay is the founder of Cloud9 Charts, an analytics platform built for modern data architectures, featuring native support for Couchbase and N1QL. Follow them on twitter @cloud9charts This post uses the NYC...

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

New to NoSQL? Meet N1QL!
A few years ago NoSQL might have sounded like a alien monster, but given the advances in the technology and how modern web and mobile applications are storing and accessing data, it is and has become a critical part of...

Querying for Couchbase Documents in a NativeScript Angular Mobile Application
I recently wrote about using Couchbase as a key-value store in a NativeScript iOS and Android application built with Angular. In this example we saw how to collect user profile information to be saved or loaded from Couchbase on the...

Using Couchbase in a Golang Websocket Chat Application
Not too long ago I wrote about creating a chat application that used Angular 2 for the front-end and Golang for the back-end. The message communication between the two was possible because of websockets. In this example, any number of...

Couchbase .NET SDK 2.0.2 released Today!
Today we are releasing another bug fix and maintenance release of the Couchbase .NET SDK: 2.0.2. This is a follow up release to 2.0 and 2.0.1 and most notably provides support for N1QL DP4 which is now merged with the...