Category: SQL++ / N1QL Query

Couchbase vs. MongoDB: NoSQL Misconceptions Part 1

Couchbase vs. MongoDB: NoSQL Misconceptions Part 1

Misconceptions about NoSQL have been around for as long as NoSQL itself. It’s always good to get different perspectives, so I’m kicking off a new blog series about NoSQL misconceptions, specifically when it comes to two of the top document...

June 3, 2022
Traverse Hierarchy with SQL++ User-defined functions (UDFs)

Traverse Hierarchy with SQL++ User-defined functions (UDFs)

User-defined functions (UDFs) are a feature that exist in most RDBMS. Whether it is Oracle PL/SQL (Procedural Language for SQL), SQL Server T-SQL (Transact-SQL), PL/pgSQL (Procedural Language/PostgreSQL), or other variants, all these languages have the general characteristics of providing a...

May 26, 2022
NoSQL DBaaS benchmarks: which cloud comes out on top?

NoSQL DBaaS benchmarks: which cloud comes out on top?

The COVID-19 pandemic has substantially increased the pace of digitization, and for many organizations, data demands have never been higher. As enterprises accelerate their digital transformation journeys, the need to quickly and efficiently scale their database infrastructure to meet increased...

April 26, 2022
Creating Python and JavaScript User Defined Functions For Geospatial Queries

Creating Python and JavaScript User Defined Functions For Geospatial Queries

SQL++ queries can access data stored in your Couchbase cluster in a variety of ways. There are situations where having the business logic as part of your data queries can also be beneficial. SQL++ supports this with User Defined Functions...

April 20, 2022
Optimize Performance of External Analytics Collections in Couchbase

Optimize Performance of External Analytics Collections in Couchbase

It is crucial to plan for performance optimization and resource utilization now that there is support for external Couchbase Analytics collections (AWS S3 and Azure Blob Storage). External Couchbase Analytics collections read the data from external storage and do not...

Why Uplevel From MongoDB™

Why Uplevel From MongoDB™

Today’s applications need to deliver a great experience to users anywhere, all the time. For business-critical applications, there is no downtime, they must support customers 24/7, 365. Applications are being architected to run on micro-services and to be developed in...

February 22, 2022
Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0

Analyzing Statistics for Cost-Based Optimization in Couchbase 7.0

Couchbase Server 7.0 (Enterprise Edition) introduced a Cost-Based Optimizer (CBO). Previous versions of Couchbase Server used a Rule-Based Optimizer (RBO). Couchbase Server has naturally evolved from RBO to CBO like most major relational database systems. The CBO uses cost estimates...

New RBAC Roles in Couchbase 7.0

New RBAC Roles in Couchbase 7.0

Couchbase Server version 7.0 introduces some important changes as part of the role-based access control (RBAC) authorization system.  Couchbase Server has allowed fine-grained access controls to the platform with RBAC for administrators since version 4.5 and all users since version...

Top Blogs of 2021 – Part 2

Top Blogs of 2021 – Part 2

And now for Part 2 in our series, here are the top 5 blog posts published in 2021: 5. How we implemented distributed multi-document ACID transactions in Couchbase, by Denis Rosa In this blog post, we gave you an overview...

December 29, 2021
How to Improve Database Performance: 5 Steps You Can Take

How to Improve Database Performance: 5 Steps You Can Take

Deploy a Performance Monitoring Solution Use the latest Commercial version of Couchbase Size your infrastructure accordingly Use Prepared Statements Optimize Indexes There are many steps on the road to better database performance. But first it is necessary to ask what...

How Couchbase Simplifies Data Science (Part 1)

How Couchbase Simplifies Data Science (Part 1)

This post was co-authored by Karen Yuan, a High School Intern.  Data science extracts knowledge from data and applies that knowledge to solve problems. In the next two posts, we will learn how the Couchbase Data Platform can meet various...

How to Denormalize Imported Documents from RDBMS Tables Using N1QL

How to Denormalize Imported Documents from RDBMS Tables Using N1QL

Data migration is full of challenges. While migrating from a relational database (RDBMS) like SQL Server or Oracle, your main challenge comes at the time of denormalizing migrated documents as per the target data models. With the introduction of scopes...

December 1, 2021