Category: SQL++ / N1QL Query
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...
Cihan Biyikoglu, Director of Product Management, Couchbase
April 22, 2016
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...
Pranav Mayuram
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,...
The Couchbase Team
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...
Laurent Doguin, Developer Advocate, Couchbase
March 30, 2016
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...
Cihan Biyikoglu, Director of Product Management, Couchbase
March 20, 2016
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...
Cihan Biyikoglu, Director of Product Management, Couchbase
March 11, 2016
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...
Cihan Biyikoglu, Director of Product Management, Couchbase
March 11, 2016
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...
Nic Raboy, Developer Advocate, Couchbase
February 25, 2016
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...
Matthew Revell, Lead Developer Advocate, EMEA, Couchbase
February 24, 2016
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...
Todd Greenstein
February 4, 2016