Category: SQL++ / N1QL Query
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
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
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...
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)
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
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...
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...
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...
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...
![Get Started with Couchbase + Java [Developer Walkthrough]](https://www.couchbase.com/blog/wp-content/uploads/sites/1/2021/10/get-started-couchbase-java-sdk-developer-walkthrough-800x280.jpg)
Get Started with Couchbase + Java [Developer Walkthrough]
If you’re a developer who’s new to Couchbase, this article helps you get started. This weekly walkthrough series helps you understand the basics of connecting to Couchbase, shows you how to retrieve and modify data in Couchbase Server, how to...
Introducing Ottoman v2.0: An ODM for Node.js & Couchbase
On behalf of the Couchbase team, I’m absolutely thrilled to announce the General Availability of Ottoman 2.0. Ottoman is an Object Document Mapper (ODM) library for Couchbase and Node.js that maps JSON documents stored in Couchbase to native JavaScript objects....