Category: SQL++ / N1QL Query

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

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

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

April 3, 2016
Native Data Visualization and Reporting with Cloud9Charts and Couchbase with N1QL

Native Data Visualization and Reporting with Cloud9Charts and Couchbase with N1QL

Native Couchbase N1QL Business Intelligence & Reporting This is a guest blog post by Jay Gopalakrishnan, founder of Cloud9 Charts, a Business Intelligence platform for multi-structured data with native NoSQL integrations. N1QL provides unprecedented query capabilities on Couchbase with sort,...

March 31, 2016
Storing, Indexing and Searching files with Couchbase and Spring Boot

Storing, Indexing and Searching files with Couchbase and Spring Boot

I have been wanting to showcase most of the new Couchbase’s search features available in 4.5 in one simple project. And there have been some interest recently about storing files or binaries in Couchbase. From a general, generic perspective, databases...

Visual Studio Code, the Integrated SQL Editor and N1QL Query Execution

Visual Studio Code, the Integrated SQL Editor and N1QL Query Execution

Couchbase Server 4.5 and GO_CBQ With Couchbase Server 4.5, we are providing a new enhanced commandline query execution tool called “go_cbq”. The new binary comes with capabilities for scripting support, connection management and more. I have been using go_cbq for...

PowerBI & Couchbase Server 4 – Reporting over JSON Data with native connectivity through N1QL REST API

PowerBI & Couchbase Server 4 – Reporting over JSON Data with native connectivity through N1QL REST API

PowerBI and Native JSON Processing PowerBI is one of the great new reporting environments you can use to visualize data. One great advantage of PowerBI is its native JSON support and built-in programmable transformation engine. Power-BI can simply directly talk...

Excel and Couchbase Server v4 with N1QL – No ODBC Required!

Excel and Couchbase Server v4 with N1QL – No ODBC Required!

Microsoft Office 2016 with Excel and Native JSON Processing Microsoft Office and Excel is the de-facto reporting environment for many of us. One great advantage of Excel is its native JSON support and built-in programmable transformation engine. Excel can simply...

Load Nested Models With Ottoman When A Parent Model Is Found In Node.js

Load Nested Models With Ottoman When A Parent Model Is Found In Node.js

Previously I wrote about easily developing Node.js and Couchbase apps using Ottoman for ODM. That post was just a taste of what Ottoman can do and how you can compare it to the things Mongoose can do with MongoDB. This...

Sub-documents: find and change only what you need

Sub-documents: find and change only what you need

What separates a document store from a key-value store? A document database can query and manipulate the contents of what it stores, whereas the value remains an opaque mystery to the key-value store. With Couchbase Server 4.5, we’ve introduced our...

Prepare for This!

Prepare for This!

Get Prepared…. One of the more impressive aspects of using N1QL is the ability to use prepared statements. What are prepared statements? Why use them? What’s the big deal? Consider the following example from the travel-sample bucket and dataset that are bundled...

February 4, 2016