Category: SQL++ / N1QL Query
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...
Hussain Towaileb, Software Engineer
March 31, 2022
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...
Rick Jacobs
February 22, 2022
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...
Bingjie Miao, Principal Software Engineer Couchbase
January 25, 2022
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...
Ian McCloy, Director Product Management
January 13, 2022
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...
Isheeta Lad
December 29, 2021
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...
Richard Douglas - Solutions Engineer
December 28, 2021
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...
Poonam Dhavale, Principal Software Engineer
December 21, 2021
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...
Gurmeet Singh
December 1, 2021
ML Meets NoSQL: Integrating Python User-Defined Functions with SQL++ for Analytics
After conversations with our customers about the delay in obtaining analytical insights from their Python-based machine learning models, we set out to create a seamless pipeline from Python to Couchbase Analytics that returns faster insights in real time. Introduction With...
Announcing the 3.0 Beta Release for Mobile & Edge Computing
We’re pleased to announce the GA release of the Couchbase Lite 3.0 and Sync Gateway 3.0 platforms for mobile and edge computing solutions This major release makes great strides in the area of edge computing by expanding our edge device platform...
Priya Rajagopal, Director, Product Management
October 23, 2021
Level Up Your Data Visualization with Charts in Couchbase 7.0.2
If a picture is worth a thousand words, data visualization is worth a thousand data points. With the release of Couchbase 7.0.2, the Query Workbench (and the Analytics Workbench) now include a Charts tab that allows you to create charts...
Isha Kandaswamy
October 22, 2021
Accelerate Your Database Migration to Couchbase with erwin Data Modeler
The relational database has been foundational to the information economy just like the steam engine enabled the industrial revolution. However, the past success of relational databases (RDBMS) is no measure for what’s needed in today’s economy. Digital transformation driven by...
Danny Sandwell & Yves Laurent
October 14, 2021