Category: SQL++ / N1QL Query
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...
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...