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...
Keshav Murthy
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...
Keshav Murthy
October 20, 2018
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...
Hod Greeley, Developer Advocate, Couchbase
August 22, 2018
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,...
Tyler Mitchell
July 23, 2018
How to Join JSON: Couchbase N1QL vs. MongoDB Query
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...
Keshav Murthy
July 11, 2018
Tutorial: Using the Query API With Couchbase Lite, iOS
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 iOS Swift app. In...
Understanding Index Grouping And Aggregation in Couchbase N1QL Query
Couchbase N1QL is a modern query processing engine designed to provide aggregate SQL for JSON by index on distributed data with a flexible data model. Modern databases are deployed on massive clusters. Using JSON provides a flexible data mode. N1QL...
Sitaram Vemulapalli
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...
Johan Larson
March 19, 2018
ANSI JOIN Support in N1QL
Overview ANSI JOIN support is added in N1QL to Couchbase version 5.5. In previous versions of Couchbase, join support was limited to lookup join and index join, which works great when the document key from one side of the join...
Bingjie Miao, Principal Software Engineer Couchbase
March 5, 2018
Introducing Full Text Search (FTS) in Couchbase Mobile 2.0
Couchbase Mobile 2.0, introduces powerful Full Text Search (FTS) capabilities on your JSON Documents. This is part of the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you are familiar with SQL,...
Priya Rajagopal, Senior Director, Product Management
January 17, 2018
Full Text Search: Better Queries for NoSQL in Node.js
Querying a database with SQL or a similar technology is great until you find yourself needing to query natural language. Do you degrade the performance of your queries with wildcards? How about searching across multiple columns or properties? What happens...
Nic Raboy, Developer Advocate, Couchbase
January 16, 2018
How to Query Array Collections in Couchbase Lite
One of the major features introduced in Couchbase Lite 2.0, is the new Query interface based on N1QL, Couchbase’s declarative query language that extends SQL for JSON. If you are familiar with SQL, you will feel right at home with...
Priya Rajagopal, Senior Director, Product Management
January 3, 2018