Category: SQL++ / N1QL Query

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

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

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

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

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

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

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

Using Covering Indexes on a Multiple Document Type Bucket

I was recently working on a project that made use of N1QL for querying Couchbase Server data. This was an internal Java application that I was hosting on a low budget Amazon EC2 instance. My problem here is that my...

NDP Episode #4: Querying with NoSQL

I am pleased to announce that the fourth episode of the NoSQL Database Podcast is now available.  In this episode titled Querying with NoSQL, I’m joined by two of my colleagues, Keshav Murthy and Prasad Varakur.  We discuss how querying works...

High Performance NOSQL Query Consistency with Couchbase 4.5

High Performance Consistency When using Couchbase as your system of record we provide a best in class indexing experience using our global secondary indexes and workload isolation through dedicated indexing nodes. We’ve improved that experience even further in Couchbase 4.5...

May 10, 2016

Faster Indexing & Queries: Introducing Global Secondary Indexes (GSI) – PART I

No one doubts that indexing and query with big data is challenging. Big data comes at you fast, with high velocity, variety and volume! 100Ks of updates/sec and TBs of data to scan – you cannot do this real-time unless...

How to: Create a copy of your bucket with a single statement with Couchbase Server

Batch data manipulation can be super handy for all sorts of operations. Good news is, DML (data manipulation language) in N1QL provides full support for, not just singleton operations, but for powerful bulk/batch data transformation. Here are a few powerful...