Tag: N1QL

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...

Couchbase Catalogs for the SQL Server DBA

Couchbase Catalogs for the SQL Server DBA

In this post, we introduce System Catalogs in Couchbase and walk through a specific use case compared to SQL Server. If you’re like me, after 20 years of working with SQL Server, you tend to pick up on things that...

January 12, 2022
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...

Introducing Charts for Query & Analytics

Introducing Charts for Query & Analytics

Couchbase Web Console is a browser-based, interactive graphical user interface that supports the management of all services in Couchbase Server. It also includes the Query & Analytics Workbench that allows developers to interactively manipulate Couchbase data, explore the schema, and...

December 9, 2021
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
ML Meets NoSQL: Integrating Python User-Defined Functions with N1QL for Analytics

ML Meets NoSQL: Integrating Python User-Defined Functions with N1QL 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...

, November 8, 2021
Announcing the 3.0 Beta Release for Mobile & Edge Computing

Announcing the 3.0 Beta Release for Mobile & Edge Computing

We’re pleased to announce the public beta 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...

Get Started with Couchbase + Java [Developer Walkthrough]

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...

October 7, 2021
Introducing Ottoman v2.0: An ODM for Node.js & Couchbase

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....

September 30, 2021
How to Build Indexes for Full-Text Search in Couchbase 7.0

How to Build Indexes for Full-Text Search in Couchbase 7.0

Indexes are the underlying infrastructure that make full-text search possible. The new Scopes and Collections feature in Couchbase Server 7.0 makes full-text search in your applications more powerful than ever before. Powering those searches requires full-text indexes. This article provides...

How to Build Observability Dashboards with Prometheus, Grafana & Couchbase

How to Build Observability Dashboards with Prometheus, Grafana & Couchbase

You’ve certainly heard it before: “What gets measured gets done.” It’s true: what you observe and measure is what you can improve. The key to any improvement is to first identify what to measure and then collect the related metrics....