Category: N1QL / Query

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

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

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

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

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

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

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!

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