Category: SQL++ / N1QL Query

Query Workbench – New to Couchbase 4.5
Query Workbench – New to Couchbase 4.5

The Query Workbench is an indispensable tool for developers who are working with Couchbase Server, especially those working with N1QL. Sure the cbq command line tool is helpful, but the Query Workbench has a nice UI and also shows off...

CData’s Drivers Provide SQL Access to Your Couchbase Data
CData’s Drivers Provide SQL Access to Your Couchbase Data

The post focuses on CData has created an entire suite of drivers to help Couchbase customers best connect to their data. Learn more about Couchbase drivers.

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

See what is Memory Optimized Global Secondary and learn the differences between standard Global Secondary Indexes vs memory optimized GSIs.

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

Using Covering Indexes on a Multiple Document Type Bucket
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
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 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...

Couchbase with Windows and .NET – Part 2
Couchbase with Windows and .NET – Part 2

Couchbase with Windows and .NET – Part 2 – Lingo This blog post is part 2 of a series. Part 1 covered how to install and setup Couchbase on Windows. In part 1 – Setup, I showed the very basics...

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

This blog focus on what is Global Secondary Indexes (GSI). Furthermore, see how to do Indexing in Distributed Database Systems.

How to: Create a copy of your bucket with a single statement with Couchbase Server
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...

Detecting Expirations Before They Happen with Couchbase Server & N1QL
Detecting Expirations Before They Happen with Couchbase Server & N1QL

There are many use cases where auto expiry of documents work perfectly. Maintaining session state, shopping carts, price quotes for travel and more. In all these cases, applications using Couchbase Server, set the expiry time to seconds, minutes or hours...

Exploring Couchbase and N1QL through Touchbase using Node.js and Angular.js – Part 5: Graphing User Data
Exploring Couchbase and N1QL through Touchbase using Node.js and Angular.js – Part 5: Graphing User Data

Part 5: Graphing Necessary Materials: Node.js Express Chart.js Node Modules Used: tc-angular-chartjs body-parser moment.js Summary: To maintain a social network, and improve the experience for an end-user, it’s important to keep track of information about these users and their usage...