Category: SQL++ / N1QL Query
Workaround for N1QL* Queries in the .NET SDK
This blog was originally posted on David Ostrovsky's personal blog. To see to original blog post, click here. TL;DR: SELECT myBucket.* FROM myBucket A change in the way N1QL returns results for star queries in Couchbase Server 4.1 seems to have...
N1QL vs TSQL – Aggregations with Couchbase Server vs SQL Server
SQL has been around for a loooooong time. It is very intuitive and efficient way to process structured data and has been the choice for databases for many years. With the world of BIG DATA however, data has velocity, variety...
Couchbasics: How Functional and Performance Needs Determine Data Access in Couchbase
There are multiple ways of getting data in and out of Couchbase. Notice that I did not say querying, I said in and out…on purpose. Not all ways of getting data in and out of Couchbase are querying like in...
Data modelling for N1QL
In my posts on key-value data modelling with Couchbase, the main concerns were: * when to embed data and when to refer * building secondary indexes * key design. In a N1QL world, we’re still thinking about similar things and in this post...
Hands-on with N1QL in London!
We're kicking off the 2016 Couchbase meet-up calendar in London with a hands-on N1QL workshop! Come and join us on January 20th at the Couchbase London office, in Shoreditch, to learn: the fundamentals of N1QL: what you can do and why how N1QL...
Getting Started with Tableau and Couchbase
Getting Started with Couchbase and Tableau With the release of Couchbase 4.0, business intelligence users now have access to document data stored in Couchbase via N1QL and ODBC/JDBC drivers from SIMBA. This is a quick start guide on how to integrate a...
Introducing Linq2Couchbase Developer Preview 1: The Linq provider for Couchbase N1QL!
*Sample code for this post is available in the couchbase-net-examples project here. I am very excited to announce developer preview #1 of the official Linq provider for Couchbase N1QL! This is a very early pre-release to introduce the provider, preview...
Couchbase .NET SDK 2.1.3 (and 2.1.2) released!
Today we are releasing a follow up release to 2.1.0 and 2.1.1 that includes support for Multidimensional Scaling (MDS) for Couchbase Server 4.0 Beta and a plethora of bug fixes! In this post i’ll explain what MDS is and...
N1QL Samples
Learn N1QL by sample N1QL is the document query language used to query data in Couchbase Server (CB). N1QL will be an integrated part of CB 4, until then there is a preview version available. SQL for JSON Documents N1QL...
Indexes for N1QL: or how I got an order magnitude speed increase
Indexes for N1QL: or how I got an order magnitude speed increase In Couchbase 4.0 we introduced N1QL query language: a flexible query language that brings SQL-like query to JSON documents. Whenever we talk about N1QL the conversation always opens...
Data Modelling in Document Databases for the Relational DBMS-minded
Data modeling for relational databases uses entity relationship diagrams, normalization and more…. Techniques which have evolved to perfection over the years. However data naturally does not exist in this full normalized form in real world applications. Document databases like Couchbase...
Are you up for a N1QL challenge?
We are looking for some awesome developers to show the world what creative apps they can build using N1QL and Couchbase 4.0 beta. Need some infrastructure to run your app? Give Joyent a try. Joyent's Triton Elastic Container Service...