Category: N1QL / Query
Partner Blog: Couchbase 4.5 – Native BI Support
Earlier this week, Couchbase launched the latest version of its flagship NoSQL database, 4.5, with powerful additions to N1QL, faster queries and indexing, role based security and a range of other features. At Cloud9 Charts, we are pleased to add...
James oquendo, Senior Software Engineer, Couchbase
June 27, 2023
Streamline Couchbase Analytics with User-Defined Functions (UDF’s)
Introduction One of our exciting new features in Couchbase Server 7.0 Beta is support for User-Defined Functions (UDFs) in the Analytics Service. UDFs are reusable and parameterizable N1QL queries that can be used to modularize queries and increase code reuse....
James oquendo, Senior Software Engineer, Couchbase
January 4, 2021
N1QL User Defined Functions
Introduction Couchbase Server 6.5 introduced User Defined Functions as a Developer Preview feature. N1QL is primarily a declarative language – where you ask what to get, and the language works out for you the actual method. While declarative languages have...
James oquendo, Senior Software Engineer, Couchbase
December 14, 2020
Indexing Service Optimizations with Couchbase Collections
Couchbase Collections introduces the separation of the bucket data into logical scopes and collections, on top of the Couchbase JSON database. The separation allows the data to be separated out to different schema and tables, a concept that most RDBMS...
James oquendo, Senior Software Engineer, Couchbase
December 9, 2020
New in Couchbase Server 7.0: N1QL per request memory quota
Introduction Unlike other services, the N1QL service so far hasn’t offered the ability to size its memory footprint. The principal reason for this disparity boils down to one simple fact: while the bulk of the memory consumption for services like...
Collections – simplify your analysis with Couchbase Analytics
Introduction Couchbase is excited to announce a new product feature of Collections as part of its beta release 7.0 and support for collections has been extended to Analytics Service as well. Collections and scopes are logical containers within a bucket....
James oquendo, Senior Software Engineer, Couchbase
December 1, 2020
Cost Based Optimization with Couchbase JSON database
Couchbase Query Cost Based Optimization (CBO) was released as a Developer Preview in Couchbase 6.5, and it is now ready for GA with Couchbase v7.0. While CBO is a ubiquitous feature with traditional RDBMS, and that users have come to...
James oquendo, Senior Software Engineer, Couchbase
November 30, 2020
Simplifying Query & Index with Collections
Couchbase Collections available with the upcoming version 7 brings Couchbase JSON database closer to that of other RDBMS. Collections will make it easier for customers who are looking to migrate their current RDBMS data model to Couchbase document model. This...
James oquendo, Senior Software Engineer, Couchbase
November 25, 2020
Couchbase Transactions with N1QL
Couchbase introduced ACID transactions in its v6.5 release with the Couchbase SDKs, and this has now been extended to Couchbase N1QL Query in the upcoming release 7. A quick recap – Couchbase provides support for multi-document ACID transactions for its...
James oquendo, Senior Software Engineer, Couchbase
November 17, 2020
DataGrip Setup for Couchbase
DataGrip from JetBrains has added NoSQL Couchbase support. It was first made available in their 2020.3 EAP (Early Access Preview) DataGrip 2020.3 EAP is Open! – Couchbase support – Grants – More powerful value editor – Opening transposed tables –...
James oquendo, Senior Software Engineer, Couchbase
November 11, 2020
Taming the Gerrymander with Geospatial Search
The Basics Before you read any further, please take a few minutes and read the excellent post on geospatial search in Couchbase, as published by my friend and colleague Brian Kane: https://staging.couchbase.com/blog/geospatial-search-how-do-i-use-thee-let-me-count-the-ways/ Go ahead; I’ll wait. Now that you’re back,...
James oquendo, Senior Software Engineer, Couchbase
November 4, 2020
Halloween Problem: Solution in N1QL.
Learning SQL is easy; Implementing SQL, not so much. Halloween has come and gone. But, the tricks of the Halloween problem is here to stay! This has to be solved by databases every day. SQL made the relational database easy,...
James oquendo, Senior Software Engineer, Couchbase
November 3, 2020