Tag: query

JSON to Insights: Fast and Easy

Co-author:  Sitaram Vemulapalli, Principal Engineer, Couchbase R&D. “The answer my friend is hiding in JSON” – Bob Dylan There are a lot of public JSON datasets and then is awesome JSON datasets. Every company, including yours, has stored a lot of...

/ December 1, 2018

Using N1QL with Couchbase Eventing Functions.

Now, this is not the end. It is not even the beginning of the end. But it is, perhaps, the end of the beginning. — Winston Churchill Updating data is usually not the end, but usually a progress of a...

/ October 20, 2018
Analytics Example

The Couchbase Data Platform in Action: Analytics

Contents What is CBAS and how does it compare to “standard” Couchbase? Example Data and Configuration Code and Queries Web Client Web Server and Queries Querying with SQL++ Query Optimization Query Results and REST Response Conclusion Postscript With the release...

Rowing team splashing and celebrating in scull on lake

Couchbase Server 5.5 Released

Announcing Couchbase Server 5.5 Couchbase Server 5.5 production release is now available! We are very excited to share more information about this substantial extension of the Couchbase Data Platform. This release introduces several new Enterprise Grade features relating to agility,...

/ July 23, 2018

Joining JSON: Comparing Couchbase N1QL & MongoDB

As NoSQL databases evolved, each added higher level APIs or languages to help programmers to complex things easily. SQL, having done that for relational data, showed the way. In SQL, developers say WHAT needs to be done and the database...

/ July 11, 2018

Tutorial : Using the Query API with a Prebuilt Couchbase Lite 2.0 Database in an iOS App

Couchbase Lite 2.0 is a powerful NoSQL embedded data store for iOS, Android and .Net Mobile Platforms. In an earlier tutorial, we explored the basics of Database and Document CRUD operations using Couchbase Lite within your swift app. In addition...

render_documentation_xcode_playground

Xcode Playground for Exploring Query API in Couchbase Lite 2.0

This post is a step-by-step guide for using an Xcode Playground for exploring the new querying API in Couchbase Mobile 2.0. The Couchbase Lite 2.0 Release introduces a simplified query API based on N1QL, Couchbase’s declarative query language that extends...

Understanding Index Grouping And Aggregation in Couchbase N1QL Query

Couchbase N1QL is a modern query processing engine designed to provide SQL for JSON on distributed data with a flexible data model. Modern databases are deployed on massive clusters. Using JSON provides a flexible data mode. N1QL supports enhanced SQL...

/ April 3, 2018

Auditing Couchbase N1QL Statements

Couchbase Server 5.5 includes the ability to keep a record of all N1QL actions taken by users. This is part of Couchbase’s more general audit functionality, introduced in 5.0. Auditing is only available in Enterprise edition. Auditing lets the administrators...

/ March 19, 2018

ANSI JOIN Support in N1QL

Overview ANSI JOIN support is added in N1QL to Couchbase version 5.5. Previous versions of Couchbase only support lookup join and index join. Lookup join and index join works great when the document key from one side of the join...