Engineering

User-defined functions (UDFs) and stored procedures (SPs) allow users to define a set of queries that can be executed at the database by providing only the function or procedure name and any relevant parameters. They provide building blocks for users to compose complex queries, which makes applications less error prone since users don’t need to repeatedly provide the complex query. Another benefit of UDFs/SPs is that they enable better performance by moving more computation closer to the data. There are fewer round trips between the application and database to get the results the user wants.

Drew Kimball

August 27, 2024

This is the second article in the series, Unlocking Enterprise Scale with CockroachDB on Microsoft Azure, where we help you utilize the best that CockroachDB on Azure has to offer. In this blog, we will explore different production options, deployment strategies, and key considerations for single-region and multi-region setups, while introducing key integrations with the Azure ecosystem.

David Joy

August 20, 2024

After choosing CockroachDB as your next-generation storage system, you may wonder, “How do we move our organization’s data into CockroachDB?”

Ryan Luu

July 18, 2024

Welcome to our new blog series, "Unlocking Enterprise Scale with CockroachDB on Microsoft Azure." We'll explore how CockroachDB, our cloud-native distributed SQL database, can be leveraged on Microsoft Azure to achieve unprecedented scalability, resilience, and performance for enterprise applications.

David Joy

June 27, 2024

Moving past mainframes is a big decision, but it’s the right choice for a growing number of enterprises. The agility and scalability of cloud architectures are proving too advantageous for organizations to ignore, as they race to gain a competitive edge.

David Weiss

June 6, 2024

Admission control is the system in CockroachDB that prioritizes work during different types of node overload. In a properly sized cluster, where the work does not exceed the resource capacity, all work proceeds uninterrupted and effectively receives equal priority.

Jon St. John

May 14, 2024

Raft is a consensus algorithm used in distributed systems to ensure that data is replicated safely and consistently. That sentence alone can be confusing. Hopefully the analogy in this post can help people understand how it works. In honor of national Mean Girls day (“on October 3rd he asked me what day it was”), I present the Raft Consensus Algorithm as explained through the movie Mean Girls. (For a great, more technical overview of Raft, we recommend The Secret Lives of Data).

After publishing \\[a post about why we chose Go for CockroachDB](https://www.cockroachlabs.com/blog/why-go-was-the-right-choice-for-cockroachdb/), we received questions about how we deal with some of Go’s known issues — especially those related to performance, garbage collection, and deadlocks.

Jessica Edwards

September 26, 2023

We’ve all done it. Imagine you’re browsing around the AllSaints online shop, dreaming about refreshing your fall wardrobe. You find a couple items and add them to your cart. You continue browsing but then, for some reason, you don’t check out. Instead, you close the browser tab and move on. In the e-commerce world, this is what’s known as shopping cart abandonment.

Aydrian Howard

July 26, 2023