Tag: SQL

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

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

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

Developing an API with Node.js using Couchbase NoSQL and N1QL

Have you ever wanted to create a RESTful API with Node.js, but wasn't sure where to start?  How do you design your endpoints or interact with the data layer?  How do you store your data? In this, start to finish,...

Moving SQL database content to Couchbase

Since the GA release of N1QL, we get a lot of questions about moving content from a SQL database to Couchbase. There are many different ways to do so. Today, I have chosen what is probably the simplest. I will...

Introducing N1QL: SQL gene in NoSQL

SQL Gene in NoSQL: Introducing N1QL NoSQL have been a reaction to relational movement that required rigid schema. Relational database bundled SQL query language to powerfully search and reshape the results to compensate. With version 4.0, Couchbase Server contains both the...