Category: SQL++ / N1QL Query

.NET and Couchbase – July 2016, Findlay Ohio (video)

.NET and Couchbase – July 2016, Findlay Ohio (video)

I was a guest speaker at the FANUG (Findlay Area .NET User Group) on July 26, 2016. My topic was Full Stack Development with .NET and NoSQL. The group and venue kindly allowed me to record the session, and so...

July 29, 2016
Node.js and Couchbase – July 2016, Columbus Ohio (video)

Node.js and Couchbase – July 2016, Columbus Ohio (video)

I was a guest speaker at the CBusJS Columbus JavaScript User Group on July 20, 2016. My topic was Full Stack Development with Node.js and NoSQL. The group and venue was kind enough to let me record the session. I’ve...

July 27, 2016
Modelling the Taxlot Matching Process in N1QL

Modelling the Taxlot Matching Process in N1QL

Purpose of this Article This article enumerates how the tax lot matching process can be modelled and the run in Couchbase. While the data model itself is a subjective thing, this article is going to only list the major entities...

N1QL Scan Consistency including new AtPlus (Video)

N1QL Scan Consistency including new AtPlus (Video)

This video shows the ScanConsistency options when executing N1QL queries, and covers all the ScanConsistency options, including the new AtPlus. The source code used in this video is available on Github. If you’d like to learn more about how to...

July 18, 2016
Partner Blog: Couchbase 4.5 – Native BI Support

Partner Blog: Couchbase 4.5 – Native BI Support

Earlier this week, Couchbase launched the latest version of its flagship NoSQL database, 4.5, with powerful additions to N1QL, faster queries and indexing, role based security and a range of other features. At Cloud9 Charts, we are pleased to add...

July 1, 2016
Digging Deeper into YCSB Benchmark with Couchbase Server 4.5

Digging Deeper into YCSB Benchmark with Couchbase Server 4.5

Every benchmark raises few question marks as it answers some. So with every benchmark, you need to sift through the data yourself to get the full scoop. I have been benchmarking for a while starting at the TPC era with benchmark wars...

Partner Blog Post: SQL and N1QL in Harmony: Collaborative Query Execution in Simba Couchbase Drivers

Partner Blog Post: SQL and N1QL in Harmony: Collaborative Query Execution in Simba Couchbase Drivers

Structured Query Language (SQL) was originally designed as an intuitive query language for relational data stores. NoSQL, relatively nascent in comparison, still requires compatibility with SQL as many BI tools and applications understand it. Couchbase supports its own query language,...

June 28, 2016
Auto-Schema Discovery

Auto-Schema Discovery

So you downloaded the new 4.5 Release of Couchbase and now you are ready to get started. If you are a Developer or even a DBA you will definitely enjoy some of the major new features rolled into 4.5.  So...

June 21, 2016
New to Couchbase 4.5: AtPlus

New to Couchbase 4.5: AtPlus

What I’m learning about Couchbase is that while it aims to provide sensible defaults, it also provides options to make trade-offs. The trade-off I’m going to focus on in this blog post is Scan Consistency for N1QL queries. Couchbase 4.5...

June 21, 2016
CData’s Drivers Provide SQL Access to Your Couchbase Data

CData’s Drivers Provide SQL Access to Your Couchbase Data

Standards-Based Access to Couchbase Data So you’ve chosen Couchbase to house your data and now you’d like to be able to access that data however and wherever you’d like. If you’re building your own web, desktop, or mobile application, you...

Faster Indexing and Query: Introducing Memory Optimized Global Secondary Indexes – PART II

Faster Indexing and Query: Introducing Memory Optimized Global Secondary Indexes – PART II

In PART I, we have covered the differences in indexing with local and global indexes. We have also concluded with the 2 storage options Couchbase Server provides for global secondary indexes: standard GSI and memory optimized GSI. Lets dive into memory...

Couchbase with Windows and .NET – Part 4 – Linq2Couchbase

Couchbase with Windows and .NET – Part 4 – Linq2Couchbase

Part 1 covered how to install and setup Couchbase on Windows Part 2 covered some Couchbase lingo that you’ll need to know Part 3 showed the very simplest example of using Couchbase in ASP.NET In this blog post, I’m going...

May 18, 2016