Cockroach Labs Blog

In this article, you'll how schema changes happen with a variety of database technologies to demonstrate the importance of performing schema changes without downtime.

The total cost of database ownership can be broken down essentially into the license cost, the storage cost, and the compute cost. The focus of this blog is the reduction of storage costs.

Learn how this sports betting company built a performant, consistent, compliant platform that scales easily to new regions.

Sometimes, reading stale data is ok — preferred, even. Let's look at "follower reads" (aka "stale reads"), a technique for getting good performance from a database accessed from multiple geographic regions.

Learn to use the Calico clustermesh and CockroachDB to enable inter-cluster pod communication, achieve scalability, and implement granular security controls to solve the challenges of a multi-cluster network architecture.

How have databases evolved to handle high availability demands? This post walks through the development of active-passive, active-active, and multi-active systems.

Jason Forget joins as new President and Chief Revenue Officer to help accelerate growth on the back of significant new product capabilities

The world's top banks are leaving the legacy RDBMS that have powered their workloads for, in some cases, decades. Here's why.

In this blog post, we explore some of the intricacies of time in PostgreSQL and decipher the distinctions between Time, TIMETZ, Timestamp, and TimestampTZ in PostgreSQL

Senior engineering leaders from Xbox, Boeing, AuthZed will join Solomon Hykes to speak at KubeCrash, a virtual Kubernetes conference.

You need to identify your database rows somehow. Calling them row 1, row 2, etc. comes with some hidden hazards. There's a better way: UUIDs.

Learn why Booksy built their global order management system on top of CockroachDB and GCP.

Fault tolerance describes a system's ability to remain operational during errors, power outages, and other types of faults. How can you build a system that does that?

The fintech industry is extremely competitive and it's no longer acceptable to make tradeoffs when building your infrastructure.

For seven companies interviewed by Greenoaks Capital Partners, switching to CockroachDB resulted in annual savings of $0.5M to $8M, as well as less downtime and more developer time spent on the product.

The B2B sales team at Cockroach Labs is filled with women who are crushing their goals. They share five expert tips on how to build a career in technical sales.

One of the best approaches to ensure fault tolerance and achieve cloud portability is to run your applications across multiple clouds.

This blog post is an exploration of JSON parser performance, and, ultimately, a description of the high-performance JSON parser used in CockroachDB.

How a major global electronics company upgraded their database by moving from MySQL to CockroachDB — and saved $700k in just the first year.

Learn how SALTO Systems uses CockroachDB to build highly available access management technology.

What are the biggest challenges of application architecture today? What are the most efficient and innovative solutions to those challenges? Listen to the Big Ideas in App Architecture podcast.

In this tutorial you will learn how to use change data capture to send data from CockroachDB to Azure synapse for making business decisions based on real-time transactional data.

Learn how Paul created an open source JavaScript utility package to help convert cloud provider region codes into real locations and country flags.

Learn about distributed transactions, and the advantages and disadvantages of three different methods for implementing them.

This blog is about building an interactive serverless application with Prisma, Remix, Netlify, and CockroachDB Serverless. Why did I choose Remix over Next.js?

Real-money gaming is growing in popularity. Here's how to build a resilient, performant application in the face of demanding users and complex regulations.

Every day we get a plethora of reactions to the name CockroachDB. In this blog you'll learn about the meaning and the origin of the name and you can watch customers react to it.

Breaking up the data in your database can make it more efficient and resilient. But it can also cause problems if you're not careful.

If you are building applications on GCP or AWS, chances are you have heard of VPC peering. This blog post explains what VPC peering is and when to use it.

Handling payments can get complex in a hurry as your company scales up. But the right tools and architecture can do a lot of that hard work for you.

CockroachDB Dedicated, the fully managed service of CockroachDB, is now PCI-DSS certified by a Qualified Security Assessor (QSA) as a PCI Level 1 Service Provider.

Learn about transaction retry handling in CockroachDB – which types are handled automatically, and which types require handling in your application layer.

How to build flexible, correct, scalable, reliant Identity Access Management with Zanzibar inspired SpiceDB.

How to configure locality aware Backups in CockroachDB deployed in multi-region configurations with Azure.

In this article, we introduce the idea of Protected Timestamps: a novel way for CockroachDB to efficiently retain only relevant revisions, while safely garbage collecting old ones.

Learn how CockroachDB engineers rebuilt pieces of the system in order to efficiently delete large amounts of data while also retaining the MVCC history.

Learn how CockroachDB built a new index backfiller using an MVCC-compliant approach.

Learn how Cockroach Labs engineers rebuilt bulk operations in CockroachDB to preserve a history of what they changed.

Learn from the architecture Starburst built to support a multi-region application with CockroachDB that guarantees high availability and low latency access for its customers.

Built In today announced that Cockroach Labs won in six categories on its 2023 Best Places To Work Awards, which include all of the lists we were eligible and nominated for.

Traditionally, updating your SQL database schema once the database is in production has been a pain. But it doesn't have to be. There's a better way!

Learn how to use Cloud IAM Roles from you CockroachDB clusters in CockroachDB 22.2

In application architecture discussions, "Kafka" comes up a lot, and for good reason: it plays an important role in many event-driven architectures. Here's how it works and why you might want to use it.

Learn how Hard Rock Digital has built a highly available and compliant sports betting application to serve users in different states with CockroachDB.

Learn how to use Change Data Capture (CDC) Transformations to reduce costs and make your data pipeline more efficient.

You might be able to speed up your application by executing some functions in the database. Here's why and how you might want to do that.

Learn how to use Remix, Prisma, CockroachDB, and Tailwind to build a secret santa gift exchange application.

How CockroachDB uses control theory, studies CPU scheduler latencies, builds forms of cooperative scheduling, and patches the Go runtime.

Learn how to SSO to CockroachDB clusters using Json Web Tokens (JWT).

Learn when and how to use trigram indexes instead of Full Text Search with CockroachDB.

Probably the only computer scientist ever to have a warship named after them, the irreverent, sharp-tongued, and brilliant Grace Hopper pioneered the idea of automatic programming, developed the first compiler, and blazed a trail for women in tech.

Intelligent Insights is a tool that exposes problems detected in workloads and schemas, then offers recommendations to improve the performance of the workload.

Level up your changefeeds and simplify your ETL process by doing transformations right in the database.

Learn how you can make your distributed application more efficient by using UDFs in CockroachDB.

Netflix runs CockroachDB as part of their persistence-as-a-service offering to improve the developer’s experience and increase productivity.

Database migrations are generally undertaken for one of three reasons. In this blog we discuss why migrations happen and how to migrate faster and with more ease.

Global payments orchestration architecture is being modernized by cloud-native solutions that meet financial services security standards. Learn how Spreedly supports payment services with CockroachDB.

Heroku's free tier is disappearing. Here's how to move your Postgres database onto a different free cloud service with some useful extra features.

Distributed databases offer high availability, scalability, and performance that you might not be able to get from a traditional database. So what exactly is a distributed database, and how does it work?

Black Friday can be a dream for CEOs, but a nightmare for CTOs. Here’s how to build a backend inventory system that’s up to the challenge.

Upserts in SQL are common (and very useful!) but actually doing them can get a little complicated depending on the database you're using.

Black Friday and Cyber Monday and holiday shopping stress retail and ecommerce infrastructure. How will your site handle massive traffic? Are you giving customers accurate pricing and shipping info?

A technical stack for Nightfall.ai, a startup that uses CockroachDB for metadata storage and system of record workloads.

Learn how to achieve low latency reads in a transactionally consistent, multi-region database is a unique challenge.

Vector by Datadog and CockroachDB make it simple to collect and deliver data to other monitoring tools.

How CockroachDB helps organizations securely store their data in a DBaaS with private CockroachDB Dedicated clusters and configure egress perimeter controls.

Building video game architecture that scales presents some unique challenges. Here's a blueprint that can help solve them.

Inventory management is challenging. Here's a look at how to build modern inventory architecture based on real-world systems built by massive ecommerce companies.

Serverless application stacks have been stuck in a dilemma: Most applications need some kind of state store, but most state stores aren’t serverless. The CAKE stack solves this problem.

Learn why Netflix adopted CockroachDB as a scalable SQL database and how they’re using CockroachDB today.

It's fast and easy to spin up a CockroachDB Serverless cluster. Getting your data into it is pretty straightforward, too.

Learn why the CockroachDB SRE team chose Kubernetes over other automation and orchestration technologies.

Devsisters knew that for Cookie Run: Kingdom, they needed a robust, scalable, cloud-native database. They found one in CockroachDB.

Use this tutorial to learn how Terraform makes it possible for you to treat your databases like software.

Building a distributed payment system is a challenging proposition. Here's how Shipt managed to build a system that handles millions of payments with ease.

Cockroach Labs has just launched the first truly scalable serverless SQL database. Learn how it works and how a serverless sql database can relieve the operational burden of developers.

When you test 36 different GCP instance configurations for OLTP performance and affordability, which options rise to the top of the pile?

CockroachDB Serverless has a permanent free tier to make sure every developer always has the right capacity and 99.99% uptime — and never overspends to get them.

A distributed SQL database scales easily, is strongly consistent, is resilient, geo-replicates data, speaks SQL, offers data locality, and is cloud neutral.

James Bond explains what row-level time-to-live is, how it works, and when developers can use it to automate the deletion of expired data.

Rainmaker Games and TIMU are two examples of serverless applications in production on CockroachDB Serverless today.

Understanding the Raft Consensus Algorithm can be tough. In honor of "Mean Girls" day (October 3), we present Raft as explained through the movie "Mean Girls."

Crain's has ranked Cockroach Labs #1 in the large companies category of its 2022 Best Places to Work in New York City list. This is the third year in a row Cockroach Labs has received this ranking!

Many outages look the same, but they happen for different reasons. With high availability architecture relatively known and practiced why is it that database outages are still happening?

Senior engineers from Netflix, DoorDash, Twitter, Shipt, Starburst Data, and more presented at RoachFest, our inaugural CockroachDB conference. Here were the highlights.

In an age of constant disruption, the only viable strategy is to adapt. The ability to innovate is necessary for survival — and serverless can help make innovation simply an everyday part of doing business.

CockroachDB Serverless is now in GA, a new migration toolset, and integrations with Vercel and HashiCorp.

How to export your CockroachDB logs to AWS Cloudwatch or GCP Cloud Logging. Collect and visualize cluster logs directly, or send them to other platforms for centralized monitoring.

Learn how to build a serverless polling application with netlify serverless functions, Next.js, Pusher Channels, Twilio, and CockroachDB.

Why operational data is increasingly moving to the cloud, and how you can assess the true cost of a cloud database.

A serverless database is any database that embodies the core principles of the serverless computing paradigm. This blog details what that means for developers.

This blog post describes the career journey of Engineering Manager Rebecca Taft - from MIT to Cockroach Labs.

Three simple rules to follow when building indexes to squeeze better performance out of your SQL queries.

Existing traditional banking processes, interfaces, and underwriting methods don't adequately help startup companies control their finances. See the tech stack that solves this problem.

Multi-region application architecture helps with fault tolerance, low latency, growing a user base, increasing operational flexibility and GDPR compliance.

Use three different flavors of Linux, three different kinds of processor architectures, two different cloud providers and an onsite lab, all connected together through a virtualized software defined network to make a single ACID SQL database.

The latest research paper from CockroachDB's engineering team, "A Demonstration of Multi-Region CockroachDB", will appear in the Demonstration Track of the VLDB 2022 conference in Sydney, Australia.

By its very definition, distribution creates latency. Geo-partitioning your data in CockroachDB makes it easy to minimize p99 latency across multiple regions.

Learn how to handle test data management and data masking in a cost-effective and efficient way.

Indexes greatly improve the performance of read queries that use filters, but they come with a cost to write performance. Learn how to optimize indexes for the performance you need.

A toast to Edgar F. (Ted) Codd, godfather of the relational database. Ted Codd did for the database what Xerox PARC did for personal computers: made them accessible to everyday humans.

Being a modern media company means streaming, which comes with a variety of technical challenges. Here's how Netflix makes it happen.

Running a media streaming service means keeping things available — especially when they're popular. But accomplishing that isn't easy.

Which cloud offers the best bang-for-your buck when running transactional workloads? We ran 3,000+ tests to find out.

Relational database developers have long used the term “Entity” when designing database schemas. Meanwhile, on the software architecture side, the term “Entity” is a key component of domain-driven design. So what is the difference?

When your service is handling critical workloads, you need speed, availability, and consistency all at the same time. Here's how Form3 is making it happen.

There are no second chances with live streaming video. That's why video API provider Mux relies on CockroachDB to power its highly available, highly performant service.

How to use the DB Console GUI to identify SQL statements experiencing performance issues — plus resources for resolving any issues you find

When building a table in a SQL database, one of the most important decisions is what to use for a primary key. This can have a big impact on the efficiency of your queries.

The goal of this example is to illustrate a pattern for integrating CockroachDB with Elasticsearch, so it's simplified to just a single table which is oriented to storing data taken from URLs.

Learn how to use CockroachDB with a JPA provider like Hibernate by building a Spring Boot application that stores details of video game leaderboards in a CockroachDB.

Cockroach Labs latest SOC 2 Type II report ensures that CockroachDB and CockroachDB Serverless meet our customers' security and compliance needs, no matter which version of our managed services they choose.