Category: SQL++ / N1QL Query
5 Reasons for Developers to Attend Couchbase Connect
When it comes to online tech conferences, you’ve got options. Lots of options. If you’re a NoSQL developer, then Couchbase ConnectONLINE 2021 should be at the top of your list. This free two-day conference on 20-21 October 2021 has a...
Your Guide to User-Defined Functions in Couchbase Analytics
User-defined functions put you in the driver’s seat when it comes to querying and analyzing your data. In the Couchbase ecosystem, user-defined functions (UDFs) are reusable and parameterizable SQL++ queries that enable you to modularize queries and increase code reuse...
N1QL Now Supports User-Defined Functions
Declarative query languages have been a major gear shift in the world of database engines. The SQL++ query language (formerly N1QL) is primarily a declarative query language. You tell the query what to get and N1QL works out the rest...
Level Up Your Data Analytics with the New CUBE Functionality in Couchbase Analytics
Data analytics capabilities in Couchbase just got more robust with the 7.0 release. I’m excited to announce two new powerful capabilities now available as part of Couchbase Analytics: 1) the CUBE functionality, and 2) ROLLUP aggregation, both to help you...
5 Steps to Streamline Your N1QL Queries & Migrate to Collections
If you’re looking to migrate your data from a relational database to NoSQL, then now’s a better time than ever. The recent release of Couchbase 7.0 introduced Scopes and Collections – a new way to organize your JSON data. More...
Simplify Your Data Analysis with Scopes & Collections in Couchbase Analytics
Scopes and Collections aren’t just for organizing your data – now they can be used for your data analytics as well. As part of the Couchbase 7.0 release, support for Scopes and Collections has been extended to the Analytics Service...
Couchbase Analytics Now Supports Azure Blob Storage Using External Analytics Collections
You can now analyze even more of your enterprise data using Couchbase Analytics – without having to move or migrate a byte. Starting today, I’m excited to announce the forthcoming support for Microsoft Azure Blob Storage for external Analytics Collections...
Boost Query Efficiency with Cost-Based Optimization in Couchbase
Database users of every kind have come to expect cost-based optimization for their queries. It’s a standard feature of all traditional relational databases (RDBMS), but there hasn’t yet been a cost-based optimizer (CBO) for NoSQL document databases. That is, until...
Introducing Role-Based Access Control (RBAC) Security for Collections in Couchbase 7.0
Your data in Couchbase just got more secure. Couchbase Server 7.0 introduced Scopes and Collections to better map between relational and NoSQL data models. But the 7.0 release also includes some additional enhancements to strengthen the security of the data...
Amp Up Your Data Analysis with the New ROLLUP Aggregation in Couchbase Analytics
I’m excited to announce two new powerful data analysis capabilities now available as part of Couchbase Analytics: 1) ROLLUP aggregation, and 2) CUBE functionality, both to help you aggregate data across multiple document attributes. The addition of the ROLLUP aggregation...
The N1QL Query Language Now Supports Distributed ACID Transactions
Multi-document, distributed ACID transactions are now available in Couchbase as part of the N1QL query language. Couchbase introduced ACID transactions in its v6.5 release with the Couchbase SDKs, and this has now been extended to the Couchbase N1QL Query Service...
Ending the Relational vs NoSQL Debate, Once and for All
Couchbase 7.0 is a major milestone for databases. In the latest release, there are over 33 major innovations and 100 minor innovations, all culminating in a product that is both ground breaking and yet familiar to developers and DevOps engineers....