Category: SQL++ / N1QL Query

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

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

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 on the Pete on Software Podcast
I was invited back on the Pete on Software Podcast to talk about Couchbase. Pete is a an independent software developer/architect, and he also runs The Swift Ninja blog. Pete and I run into eachother occasionally here in Ohio, and...

Using cbimport to import Wikibase data to JSON documents
I’m busy working on some SQL Server to Couchbase Server blog posts, but in the meantime, I’d thought I’d leave you a little chestnut of JSON goodness for the Christmas weekend. Wikibase has a huge database of information. All kinds...

.NET Core and Visual Studio Code (video)
This video shows how I’m using .NET Core with Visual Studio Code and the Couchbase .NET Core SDK. Download .NET Core Download Visual Studio Code If you’d like to learn more about how to use Couchbase, please visit our Couchbase...

Moving from MongoDB to Couchbase server (revisited)
Note: this blog post is a revist of Matthew Revell’s Moving from MongoDB to Couchbase Server This is a developer-focused guide to moving your application’s data store from MongoDB to Couchbase Server. If you’re interested in migrating from a relational...

Create a RESTful URL Shortener with Couchbase and Go
Previously I wrote about creating a URL shortener using Node.js and N1QL, but I figured it would be useful to demonstrate the same in my other favorite programming language, Golang. In this video tutorial we’ll see how to create a...

Using the N1QL RETURNING keyword from .NET Core
I’ve recently learned about the RETURNING keyword in N1QL. When you add it to end of a N1QL query, that query will return the result set that was operated on. For instance, if you use an UPDATE, and that query...