Category: SQL++ / N1QL Query

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

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

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

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

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