Cockroach Labs Blog

Netflix and other innovators are headlining RoachFest 2024, the event series from distributed SQL database CockroachDB. Attend in Menlo Park, London and NYC.

What are the signs that PostgreSQL may no longer be suited for your banking and payments applications and business needs?

Learn how to modernize your database and migrate from Oracle to CockroachDB with this step-by-step guide.

Inside the architecture Starburst built to support exabytes of data across a five-region deployment with CockroachDB that guarantees high availability and low latency access for its customers.

Engineers just want to enjoy their weekend. But outages, hardware failures, and usage spikes can all lead to the dreaded PagerDuty alert, especially when the system being affected is something as critical as your metadata database.

CockroachDB joins the Google Distributed Cloud, an air gapped solution built to serve public sector institutions and highly-regulated enterprises in industries like banking, healthcare, and manufacturing.

This blog explores how to leverage CockroachDB as an OLTP database and BigQuery for OLAP, and then further enhance data capabilities using BigQueryML and Vertex AI for machine learning.

Under READ COMMITTED isolation, PostgreSQL can sometimes miss rows when performing UPDATE, DELETE, SELECT FOR UPDATE, or SELECT FOR SHARE statements. This is due to the EvalPlanQual recheck PostgreSQL adds to these statements to prevent lost-update anomalies.

The Nightfall team runs two major use cases in production on CockroachDB: a metadata storage layer for their API gateway and an interactive analytics dashboard. Read on to learn more.

User data. Application data. Customer history. User account data. Behavioral data. Metadata is at the very heart of your business, and when you do metadata right, people won’t notice you’ve done anything at all.

With the help of Antithesis, a startup from the founders of FoundationDB, CockroachDB engineers were able to track down and reproduce a most elusive one-in-a-million bug, nearly deterministically!

How do you keep databases available and performant at million-QPS scale? Here's how DoorDash does it with CockroachDB, including three tips for success at scale.

You find a mystery server under a desk. It has been sitting there, unpatched, unattended, but running — for the past twenty years. Nobody has the slightest idea of why it's there or what it's doing.

What are the benefits of running a database across multiple clouds, and more importantly: how can we actually accomplish it?

Learn how this sports betting company built a performant, consistent, and compliant mobile app that scales easily to new regions — and saved millions in projected overhead.

Every relational database needs to establish a balance between accuracy and performance. Transaction isolation levels have a direct, though often unrecognized, impact on both.

Learn the difference between an inner join, a left join, a right join, and more. Plus, learn about some special join types in SQL, like self join and cross join.

What are the advantages and disadvantages of managed database-as-a-service offerings, and why should you consider letting someone else operate your database?

Forget the anomaly table. Here's what the different transaction isolation levels mean for the design and implementation of *your* app.

Applications built on a traditional failover pattern with two data centers (and no access to a third on-prem or cloud region) used to face challenges in ensuring high resilience with CRDB. New in v23.2, physical cluster replication functionality now allows limited distribution applications to survive full cluster failures — with RPO and RTO measured in seconds rather than minutes.

How do we know what our database is actually capable of? We test it. A lot. Here's a summary of some of the tests and benchmarks we run regularly to ensure CockroachDB is performant even at global scale.

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.

Database migrations are famously difficult. They only happen when the current database is seriously holding back a business, typically in one of three ways. If this is you, CockroachDB's MOLT suite of migration tools is designed to make your database transition as boring as possible.

Cloud storage with enterprise-grade availability, durability, and performance – all for less than what the major CSPs charge? It's possible. Here's how.

CockroachDB v23.2 now seamlessly integrates with Confluent, using change data capture so users can connect the CRDB's distributed SQL capabilities with the real-time event streaming features of Confluent.

CockroachDB 23.2 includes stored procedures/UDFs, performance boosts with smarter data distribution, physical replication, expedited recovery from cloud failures, and Read Committed isolation.

To get you off to a strong start in 2024, here are our top ten most valuable “a-ha” moments and technical takeaways from the past year of Cockroach Labs' Big Ideas in App Architecture podcast.

What is cloud SQL? For that matter, what is Cloud SQL, and is it different from cloud SQL? Let's get to the bottom of this important but somewhat confusing (thanks, Google!) term.

Let's take a look at the most commonly-used data types in Postgres and how they're used in practice, including examples.

It's amazing how a series of small but unfortunate events can quickly add up to one very expensive problem. Like the time one person fat-fingered the wrong year on a mainframe JCL job, Ronald Reagan died, and the US postal service lost $500 million.

How do you build an application that’s scalable, correct, and fast all at the same time? The folks at Materialize know.

Let's take a look at RPO (Recovery Point Objective), RTO (Recovery Time Objective), and learn how to build fault-tolerant applications in which data is never lost.

At RoachFest '23, Shopmonkey Chief Technical Officer Jeff Haynie spoke about the compelling reasons the company moved their core business from Mongo to CockroachDB, and the architectural innovations they implemented to take advantage of CockroachDB’s unique multi-region capabilities.

Each year, the Cockroach Labs blog offers a smorgasbord of posts on technical, educational, informational, and cultural topics to our fellow distributed database devotees (and everyone else, too!). In case you missed them. here are some reader favorites from 2023.

CRDB is shorthand for CockroachDB: the scalable, consistently-replicated, distributed SQL database. A single instance of CRDB can scale from a one laptop to thousands of servers distributed all around the world.

The question comes at you in the hallways, the cafeteria, even the restroom: "Hey, when are WE getting AI???"? It's all anyone wants to talk to you about these days. Here is a handy four-step plan for evaluating and adopting AI so you can satisfy your curious co-workers, instead of simply screaming (on the inside, hopefully).

The crew of the Enterprise was teaching us some important lessons about databases in modern app development, although they didn't realize it.

Modernizing the data layer in your stack can be hugely beneficial, but it can also be risky. Here are three lessons Spreedly learned in their modernization efforts.

Tweeq's cloud-agnostic "no-brainer" tech stack — Go, CockroachDB, Temporal, Bazel, and gRPC, deployed on Oracle Cloud — let them build a payments platform that is scalable to millions of users, available 24/7, extensible, and easy to change.

At RoachFest23, platform engineers Rogger Fabbri and Mario Morgado documented Form3's migration from PostgreSQL and demonstrated the platform's multi-cloud architecture, using CRDB and Kubernetes to span AWS, GCP and Azure with active-active replication to survive any event — even a full cloud outage.

There’s a lot of hype around multi-cloud, but that doesn’t mean adopting a multi-cloud architecture is right for everyone. So what are the "right" reasons to adopt it?

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!

True story: It's October, 2012. A company decommissions its DR facility. Days later, Superstorm Sandy hits. You won't believe what happens next!

Running a legacy RDBMS on-prem but dreaming of multi-cloud distributed SQL? It can become reality – but only if you approach the project in the right way.

Aurora Postgres makes scaling reads easy, but writes are limited to a single node, and that limitation took DoorDash's entire application offline for hours.

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

Architects from Hard Rock Digital shares their journey building a sportsbetting and iCasino that can quickly enter new markets with CockroachDB and AWS Outposts.

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.

At RoachFest23, Fortinet Director of Software Development Louis Jia shared the story of FortiSASE’s migration from CockroachDB SH (self-hosted) to CockroachDB managed services.

Multi-cloud is not easy. Dig into our free report on the current state of multi-cloud, which contains expert advice from on-the-ground experts on pitfalls to avoid, best practices, and more.

We just released our Browser SQL Shell, which allows writing queries on CockroachDB within seconds of cluster creation.

Schema change happens — a lot. Most relational database systems require taking the DB offline to update your schema. CockroachDB, however, allows online schema changes with no disruption to your application. Here's how it works.

Here's how City Storage Systems built a highly available, highly performant persistence layer that works for mission-critical workloads at global scale WITHOUT needing a massive team.

CockroachDB nodes can be distributed across multiple locations across the globe to ensure that the data can survive outages. Learn about node locality, why this is important in CockroachDB, and how to set this in Kubernetes environments.

Here's how companies using Azure can allow access to CockroachDB for all approved users by dynamically mapping users in Azure Active Directory to a matching SQL user created in CockroachDB.

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

The root cause of many outages is human error. At RoachFest23, Thomas Boltze (Head of Cloud and Engineering Excellence with Santander) shared the core tenets of building operationally resilient systems and how to practice them in the real world — fallible humans and all.

The Halloween Problem is a rare but scary issue that can haunt relational databases, mutating your data in unexpected ways if you're not careful.

Learn how to optimize your relational database for better performance, including tuning queries, adding indexes, adjusting your schema, and more!

In this article, we share some key considerations for a technology leader involved in an M&A process and discuss the benefits of choosing flexible, cloud-agnostic technologies.

RoachFest '23, the annual user conference for CockroachDB customers, featured thirty speakers from some of the world’s leading enterprise companies describing the problems they solve, and the innovation they unlock, by using CockroachDB

Learn what kinds of problems often cause high CPU issues in Postgres, and how you can resolve them to improve database and application performance.

When critical tier 0 applications experience disruption or downtime, the outage can result in more than financial losses. Longterm damage to a company's reputation is also a significant risk. Multi-region application architecture mitigates these risks by ensuring high availability.

The cloud is, by definition, a distributed environment. But many traditional databases were created decades ago, in the age of monoliths, and now struggle to provide high availability, horizontal scalability, and performance under modern distributed workloads. So what exactly is a distributed database, and how does it work?

Operational resilience isn't the only good reason to consider multi-region deployments. For growing companies, they can make expanding into new markets faster and more cost-effective, too.

CockroachDB dedicated is on Azure, and multi-region CockroachDB serverless is in general availability, and MOLT Live Migration Service is released in preview on stage at RoachFest '23.

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

Learn to add and drop columns and their constraints safely -- without losing any data you don't want to lose -- in relational SQL databases.

Crain’s has ranked Cockroach Labs #1 in its 2023 Best Places to Work in New York City list. This is the fourth year in a row Cockroach Labs has received this ranking in the large category.

sqlfmt is an opinionated SQL formatter for writing prettier SQL. Developers should use it and stop thinking about how to format SQL.

The first question many developers ask us is why we chose to write a distributed SQL database in Go, a garbage-collected language.

In this post, we’ll share a few powerful optimizations that mitigate many of the performance problems common to Go garbage collection.

Business continuity and operational resilience are not the same thing. Here's why enterprise organizations need both to survive and succeed.

Mercedes-Benz, Ericsson, Cockroach Labs will speak at KubeCrash, a virtual Kubernetes conference on October 18, 2023.

Never forget a SQL command again with this easy-reference cheat sheet that covers everything from the basics of creating a table to ops and administration, query performance, and more!

Video platform Mux built a signing keys system on CockroachDB and Kubernetes, and deploys it across AWS and GCP.

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

To ensure fault tolerance and achieve cloud portability, run your applications across multiple clouds. Here's how three fintech companies made that happen.

Features don't matter if your application isn’t _available_ (or customers are turned away by a sluggish experience). So how do you make sure your application and database stay online and performant?

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

When it comes to payment and billing applications, engineering teams need to build idempotency into their system to guarantee data correctness and avoid duplicate payments, incorrect balances, etc.

The time is coming (maybe sooner than we think) when regulators will require a standardized approach to operational resilience in the name of public good.

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

Indexes can have a significant impact on database performance. Let’s take a look at inverted indexes, what they're for, and how to use them.

The dating industry is built on delivering a great customer experience. Not only do you need your users to like the functionality of your platform, but they also put a lot of trust into your organization to help them find a match. Learn how Doubble builds to meet expectations.

Learn how to turn a single-region application into a multi-region for performance, resilience and compliance.

It doesn’t matter whether you’re a streaming service, a sports betting app, or a social media platform – major sports drama is GOLD. At least as long as you can survive it.

Distributed database performance — both latency and uptime — can be dramatically improved with CDN-like multi-region deployments.

Avoid common pitfalls and get your new database completely serving production data on a reliable timeline by asking these five questions.

Data pipelines help move your data from one place (or more) to another. But why is that important, and how do you actually go about building and implementing one?

6 lessons that companies of any size can take away from the TayTay-Ticketmaster meltdown.

All e-commerce sites suffer from some amount of cart abandonment. This blog is about using row-level TTL in CockroachDB to add single SQL statement that solves the problem.

Cockroach labs has been named a Customers’ Choice vendor in the 2023 Gartner® Peer Insights™ ‘Voice of the Customer' report. 98% of customers are willing to recommend CockroachDB, and we received an overall rating of 4.7 out of 5.0.

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?

We are thrilled to announce that CockroachDB dedicated, the fully managed single-tenant version of CockroachDB, is now HIPAA-ready and can be used to safely store protected health information (PHI).

Multicloud is the future. But it's also a big buzzword. What do people actually mean when they say that, and how can you determine if multicloud is right for your use case?

Managing everything as code is a way of ensuring that no configuration drift occurs and that performance is as expected. This is critical when you're managing applications at scale where the impact of configuration drift is exponential.

Handling a payments system 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.

When it comes to choosing a database, deployment, and configuration for your most critical workloads, you’ve got plenty of options. But how can you strike the right balance between performance, resilience, and cost?

Let's unpack some of the architectural differences between PostgreSQL and CockroachDB to understand the challenges of the single server, single instance architecture.

Idempotency is a property of an operation that allows it to be applied multiple times without changing the result. You need it for event-driven systems.

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

In this blog, you'll learn a few reasons why CockroachDB customers believe leaving your mainframe behind for a distributed SQL solution is the right decision.

Cloud portability is a popular buzzword in tech circles, but what is it? Does it really matter? And how can you actually achieve it?

Cockroach Labs officially expanded into India, marking a significant milestone in their global growth strategy. The move to India reflects their continued recognition of global talent and the country's immense strategic potential to position the distributed SQL database to be used across the world.

How to build an architecture that ensures your metadata is highly available, consistent, and disaster-proof.

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 how to use ADD CONSTRAINT to manage primary keys, foreign keys, and other constraints in SQL databases.

Foreign key constraints are important to any SQL database, but they can also cause problems if they're not implemented correctly.

NOT NULL constraints are a ubiquitous tool for upholding data integrity. However, their performance benefits are less obvious. In this post we'll examine a few of these optimizations that transform query plans involving foreign key relationships.

Learn how Netflix moves and processes operational data from CockroachDB and other data stores.

Migrate, move, and archive data with CockroachDB CREATE CHANGEFEED statement. Simply create a new changefeed to stream row-level changes in a configurable format to a configurable sink like Kafka or Google Cloud Pub/Sub.

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

The mission of Roacher Pride is to highlight and embrace Roacher diversity and enable us to celebrate Pride every day, while educating all Roachers on LGBTQIA+ history and how to be the best ally at work and in the larger community.

Switching from Oracle can seem painful, but it is possible. This is the story of a company that did it.

This blog post explains why we built forward indexes, the main challenges that came up with the implementation, and some demonstrations of the staggering results.

A look at synchronous replication, asynchronous replication, and how data can slip through the cracks and get lost with these very common approaches to data replication/backup.

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

In a distributed database, a hotspot is an overworked node. But how can you identify them fast enough to prevent damage, or avoid them entirely?

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.

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

In CockroachDB v23.1, we are introducing a new feature which enables external SQL query editors to provide contextual suggestions on SQL syntax to developers.

Learn about Bubbles, Sparkles, and the CLI improvements that were released with CockroachDB 23.1.

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

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.

In this post Rob and Paul explain how they built Silo, a fully functioning multi-region Next.js application combining CockroachDB multi-region serverless and a multi-region Node.js (Lambda) API backed by a Geographically aware Route 53 Hosted Zone

CockroachDB dedicated is now on Microsoft Azure. Distribute data across multiple cloud regions with CockroachDB serverless. Distributed UDFs, full-text search, autocomplete, and more.

The technical definition of downtime is “a period of time when technology services are unavailable to users”. Accurate, but completely misses both the serious business impacts and the deeply human pain that can result whenever downtime — whether planned or unplanned — disrupts work.

Cockroach Labs listed on Inc.'s Best Places to Work List for the third year in a row.

In this blog post, we'll go over a few designs for a REGIONAL BY ROW table, and we'll use the example of a gambling application to motivate why different designs might be appropriate in different situations.

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

Learn what foreign keys are, how they work, and why they're critical for building high-performance SQL databases.

Disasters are expensive. Downtime (and the thought of downtime) are among the endless reasons a Software Engineer may struggle to switch off. This blog is about preventing those disasters from ever occurring.

Bolting resilience and scalability onto legacy RDMBS adds complexity and, by extension, risk. A modern data architecture can use distributed SQL to get those same advantages without the downsides. Here's how.

Learn how engineers at CockroachDB test the database and catch more obscure bugs with Metamorphic testing.

Learn about the four key architectural differences between Google Cloud Spanner and CockroachDB. Both are distributed SQL, general-purpose databases built for the cloud.

CockroachDB is an excellent system of record, but no technology exists in a vacuum. That's why we built our version of change data capture, which we call the changefeed.

In some multi-region architectures, if the primary region goes down, you'll see 10-15 minutes of RTO & 5 minutes of RPO. That's not good enough!

Learn how to design a great database schema (and why you might want a schema when there are "schema-less" database options).

Your business faces costs and risks when technology can’t evolve fast enough to meet changing business needs.

Learn the difference between horizontal scaling ("scaling out") and vertical scaling ("scaling up"), and which approach is most appropriate for your use case.

Multi-cloud deployment can minimize latency and increase availability. Here's why more companies are going multi-cloud, and how to deploy your own multi-cloud database.

Learn about the various ways you can use the new CockroachDB Cloud API, including an example that gives you insight into your database costs.

How do you calculate the total cost of a cloud database? In this blog, we’ll provide a framework to think about the costs incurred when buying a database.

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.

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.

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.

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?

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.

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.

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.

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.

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) Queries to reduce costs and make your data pipeline more efficient.

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.

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

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.

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?

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.

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.

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.

CockroachDB serverless is 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?

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.

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?

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.

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.

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

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.

Why should you learn SQL? To get better at programming, troubleshooting, and optimizing your code — even if you never touch a database.

Looking to get the best bang for your buck from one of the three public clouds? Here are more actionable insights from our 2022 Cloud Report.

SQL is an important tool for everything from performance optimization to debugging. Here's why even devs need to know SQL.

How CockroachDB delivers fast, consistent reads in every region for read-mostly data. Understanding two-phase commit (2PC), uncertainty intervals, and how to deal with clock skew.

Support for SAML and OIDC means enterprise organizations can now use services like Okta and Onelogin for single sign-on to CockroachDB managed services

Customer managed encryption keys give CockroachDB managed services customers a level of control over their own data that is comparable to a private, on-premises database installation.

Customers base their purchase decisions on item availability, price, and speed of delivery. Current trends are making it harder for retailers to provide all three reliably.

When should you use a document store and when should you use a relational database? When is the consistency of SQL preferable to the ease of NoSQL? A comparison of the two in the modern era.

A step-by-step guide for building a Ruby on Rails application using Active Record to talk with a CockroachDB Serverless database.

If you are a code newbie, you may be daunted by experienced developers' livestreams. Fear not! Here are four of our favorite beginner-friendly streamers to learn programming.

Which CPU offers the best performance and price for performance at scale when it comes to OLTP workloads? Here's how AMD and Intel stack up.

Learn how to make your Python application multi-region. And then learn how to domicile data at the row level for better application performance and compliance with regulations.

Learn how SELECT FOR UPDATE can be used to improve transaction processing in SQL.

Building a metadata store that doesn't hold back can be surprisingly tricky if you don't take the time up front to carefully consider your tech stack, schema, and architecture.

How can fintech companies scale fast, scale globally, and above all scale reliably? Here are true tales of how three global financial services companies faced, and solved, these three different challenges.

Learn how we use the OpenTelemetry Collector as a platform for integrating with third-party monitoring vendors like Datadog and Amazon CloudWatch.

For operators, architects, and developers alike, data domiciling can be one tough technical nemesis. Now, CockroachDB super regions grant your multi-region application the equivalent of data domiciling super powers!

Our 2022 Cloud Report features more and deeper testing of the OLTP performance of AWS, GCP, and Azure — which cloud is best for you?

Combining the CDC capability with Google’s Pub/Sub opens the entire Google Cloud platform, so that any application that can subscribe and receive change data feeds.

In this blog post, we describe how admission control and resource allocation work in CockroachDB to prevent your database from collapsing.

Choosing the right metadata store should be contingent on your system architecture. There is no definitive ‘right choice’. But if you are building your products or services on top of distributed systems then your choices are certainly narrowed.

Learn how to spin up a new CockroachDB cluster in the cloud right from the command line, in just a few seconds!

Our SIGMOD 2022 paper includes an extensive evaluation demonstrating that CockroachDB's new declarative SQL syntax for multi-region clusters is easy to use and supports a variety of configuration options with different performance tradeoffs to benefit a variety of workloads.

How to use the CockroachDB Cloud API to handle some of your database and cluster operations tasks.

CockroachDB 22.1 delivers updates for every stage of your journey—from your first query to your first million customers and beyond, including a new CLI and management API, Prisma support, Quality of Service, and more.

How Admission Control in CockroachDB improves performance during peak workloads.

Multi-region applications are resilient in ways that single-region (and even single AZ) applications cannot match. Designing multi-region application architecture doesn't have to be complicated — just use Google Cloud Run and CockroachDB.

An interactive demo (using D3) of CockroachDB. Watch as CockroachDB evolves with your application, from proof-of-concept, to multi-node cluster, to international deployment.

How DO we run a serverless database on Kubernetes? Let's get nitty gritty with aaalll the cluster details.

On software development, distributed SQL, and being a database nerd: A Q&A with CockroachDB Definitive Guide co-author Guy Harrison

Deploying a Netlify webapp that uses a next-gen serverless, auto-scaling database isn't nearly as complicated as it might seem.

This post explains how CAP-Consistent systems can be highly available, how the CAP theorem applies to CockroachDB, and why consistency is the better choice.

Learn how well CockroachDB and Django work together by building a simple application using the Django ORM and CockroachDB.

There are a few basic rules to keep in mind when choosing indexes for a database. A good index should have these three properties: Usefulness, Clustering, and Scattering.

How CockroachDB and Satori partnered to enhance data security for application developers.

In this tutorial we create a web application powered by Next.js and hosted on Vercel. And we demonstrate how quickly we can create a relational database on the cloud without installing it locally.

A lack of flexible indexing, denormalization patterns and other Cassandra limitations led MyWorld to migrate from Cassandra to CockroachDB.

This blog provides advice about performance, correctness, high availability, and SQL best practices for startups using CockroachDB. As well as some reasons to choose CockroachDB over Postgres.

An experiment in fuzzy matching, using SQL, with CockroachDB

Should you use Java for your Lambda apps, or should you steer clear? In this article, I'll help you decide for yourself.

In this article, we’re building a full-stack web app with Python ORM (SQLAlchemy) and CockroachDB. The idea is to make it as simple as possible — one page to display the leaderboard listing and another to add new leaderboard entries.

If your default mode of thinking is SNAPSHOT, write skew anomalies are just normal behaviour and SERIALIZABLE is throwing away perfectly good histories.

Learn how to use the two most popular database schema migration tools (Flyway and Liquibase) with CockroachDB.

In a seed-level startup, technical decisions often follow the path of least resistance. As your startup begins to find success however, you can reach a tipping point where design decisions that made sense under light loads start to look a lot like technical debt.

Aika Zikibayeva shares how she grew to become a Marketing Manager and how her team makes an outsized impact at Cockroach Labs.

If you cut too many corners, the mountain of problems you create for later could sink your startup. Here's how you can avoid too much tech debt while still moving fast.

Test Engineering is responsible for driving the quality of CockroachDB. Our mission is software validation through automated testing and program analysis.

Bitski's NFT marketplace built on CockroachDB and blockchain has proven to be an order of magnitude faster than every other NFT marketplace.

Getting your application architecture right the first time can save you major headaches further down the road.

How to use a mix of Kubernetes pods and virtual machines to deploy CockroachDB in multiple regions for geographic scale.

With this demo of highly available spatial data, show a London tourist where to find the nearest pubs. The demo uses Leaflet, Python, Flask, Kubernetes, and OpenStreetMap.

Tired of thinking about servers? Build a free serverless function and link it to a free serverless database in this easy-to-follow Python tutorial.

Devonaire Ortiz, Recruiting Programs Manager at Cockroach Labs, details how we use interview rubrics to make hiring more equitable and build better teams in the process.

Let’s explore how to use React-Static to generate our static Jamstack application. This application will store data in a CockroachDB using Netlify Functions and serve end-users using Netlify.

Deploying CockroachDB within an EKS Anywhere Kubernetes cluster provides DevOps teams with security, storage configuration, elastic scale, and performance upgrades on-premise.

“Do things that don’t scale.” That's great early stage advice. But what do you do when you reach the point where scale becomes a necessity?

How did we get to Distributed SQL? Understanding the birth of relational databases and the initial reasons behind NoSQL help the evolution make more sense.

Over the past few years we have seen the emergence of a verifiably new and significant category of database: distributed SQL. What converging factors document that this is a genuine paradigm shift? Find out in our brand new report.

How can you get great performance out of your database when huge numbers of users are going to be submitting queries within the space of a few seconds?

CockroachDB is PostgreSQL compatible in order to be accessible to an ecosystem of drivers, existing code, and developer knowledge.

Waverly Heurtelou, Technical Campus Recruiter, describes how Cockroach Labs is building and growing a recruiting program for the next generation of talent.

How to use Cilium to ‘mesh’ different Kubernetes clusters together and allow cross cluster Pod to Pod communication in multi-region application architecture.

The SQL standard defines isolation levels, but we don't have a great vocabulary for talking about consistency levels, and how these two things interact.

Learn how geo-partitioning can keep data close to users to reduce geographic latency and improve application performance.

Learn how Mythical Games is building an NFT marketplace for a decentralized gamer ecosystem with blockchain and CockroachDB.

Raydijah Walters, People Systems Coordinator, shares the story of her transition from Recruiting to People Systems, leadership of Black@CRL, and building solutions that last.

If someone knows even a little about Spanner, the first question they have is: "How does CockroachDB provide external consistency without atomic clocks?"

Lush has found lucrative logistical efficiencies after migrating from MySQL & Google Cloud Spanner to CockroachDB. Using CockroachDB has given them one global inventory management system.

Roachers on the Cockroach Labs East Sales team share what drove them to join Cockroach Labs, what they value about our culture, and what keeps them closing.

Chelsea Lee, People Development Manager at Cockroach Labs, highlights the importance of developing company values that can change with your team and drive your company culture forward.

When you need to write the same data to two storage locations, such as the database and Kafka, how can you ensure consistency?

In this blog, we're going to talk about two use cases in which using change data capture (CDC) can simplify and improve both your application and data architectures.

Vice President of Sales at Cockroach Labs, Vincent Giacomazza, shares the importance of our "One Team" mindset, teamwork, and what makes a successful salesperson.

Gartner recently published the 2021 Magic Quadrant for Cloud Database Management Systems and Cockroach Labs has been included in it for the first time.

Three tech trends to keep an eye on in 2022: Serverless reaches critical mass, developer decision-makers and transactional data moving to the cloud

Today marks a significant milestone for Cockroach Labs. We are announcing our most recent round of funding and new $5B valuation — a reflection of how our customers’ rapid advances in production deployments supports the growth of our business.

Jen Murphy, Head of Channel Sales and Chair of our Women of CRL CREWS, shares her career journey and advice for growing a sales career.

Building a gambling app requires balancing the need for high availability with the need for strong data consistency — all while maintaining extremely high performance.

If you're building a gambling app, your database has to be able to handle a lot without holding your dev team back. Here's how you can make that happen.

Any monitoring and debugging framework is incomplete without metrics. Here is our plan for building an automated alert and aggregation rule generation framework for CockroachDB metrics.

Game development presents scale and budget challenges that can be addressed with the right application architecture. This blog details gaming infra that leverages a serverless database to meet those challenges.

Database connections can get expensive at scale. Pooling connections can help, so here's what connection pooling is and how to do it!

This tutorial builds a serverless cloud-native web app using TypeScript, React, Prisma, Netlify serverless functions, and CockroachDB.

CockroachDB’s powerful change data capture (CDC) capabilities can be adapted to your application needs. But how can you leverage your changefeed setup to get the performance and durability that best fit your application?

Slow database performance got you down? The culprit might be contention. Here's what that means — and more importantly, how you can find it and fix it.

StatefulSets allow a wide array of stateful workloads to run on Kubernetes. This post covers how Stateful Sets fit with CockroachDB and Kubernetes, then jumps into a tutorial for running CockroachDB on Kubernetes.

David Delaney, a senior manager on the recruiting team, reflects on how our inclusive parental leave program and the support that follows has benefited him and many other parents at Cockroach Labs.

CockroachDB 21.2 delivers improvements that let developers integrate more seamlessly with event-driven data architecture, build against CockroachDB with more schema design and query optimization tools, and operate more easily at a massive scale.

This blog covers online gambling application architecture insights for compliance, scale, survivability, and the flexibility to adjust to all the changes in the industry.

This post defines compliance and the difference kinds of Service Organization Controls like SOC 1 and SOC 2. It also explains how a company can obtain a SOC 2 report.

Learn how to build a simple image recognition engine with Google Machine Learning and CockroachDB in this step-by-step tutorial blog.

Serverless databases are the future, but they're not perfect for every workload. Here's when to use a serverless database and when not to.

If you're building a game for scale, distributed databases make life easier. But they also need to be optimized a little differently.

All databases are ultimately just applications. A serverless database, then, is any database that embodies the core principles of a serverless application. To be a true serverless SQL database, however, you must meet a few additional requirements.

Our first-ever Rotational Product Manager, Ivory Ibuaka, tells the story of how she learned the Product Management function and made an impact in her first year at Cockroach Labs.

Learn how to build a full-stack Node.js application with CockroachDB Serverless.

What If...we could build an app that tracked or "blipped" Marvel MCU characters using Node.js, Heroku, and CockroachDB Serverless?

CockroachDB deployed on Google Cloud Platform (GCP) is a powerful pairing. Now a new strategic alliance deepens and extends that partnership.

Serverless is a crucially better way to develop and deploy, well, anything. But, seriously, what does "serverless" really mean, and what can it do for developers?

During its 169 year history, Wells Fargo & Company has repeatedly used technology to innovate and advance itself — a standout within the traditionally change-averse financial services industry. Now the third largest bank in the US is innovating once again, going not just cloud but multi-cloud.

Learn how to use TypeORM to set your TypeScript apps up with CockroachDB's free distributed cloud SQL database.

Choosing a database isn't the flashiest part of game development, but getting it right can have a huge impact on how players experience your game.

Want to make the experience of working with your Postgres database a bit more visual? Use a GUI? Here are 8 great options.

Learn about a new approach we're proposing called bounded staleness reads to address some of the potential issues with follower reads.

SQL is a key element to building modern apps.These hands-on SQL tutorials use SQL queries including CREATE TABLE, UUID, TIMESTAMP, INSERT, UPDATE, SELECT * FROM, and ALTER TABLE.

After building our presence in Canada over the course of several years, we're thrilled to announce our first dedicated office in Toronto, right near Union Station! And we are HIRING!

The Kubernetes Adoption Trends report asked 200+ engineers and architects how they deploy K8s in production. We dig in on production workloads, DevOps team structures, and deal-breakers.

Unless you choose a Kubernetes-native database, you will fall short of the orchestration magic it renders possible. So what makes a database Kubernetes-native?

Learn how you can spin up a free cloud database on GCP or AWS in just a few minutes — faster than you can make a bowl of ramen!

Modern databases offer huge advantages over legacy systems, but the prospect of migrating can be scary. Here are some real-world tips for getting it right.

As a retailer, using a distributed SQL database lets you simplify application architecture while also increasing developer productivity. Even small tech teams can handle the complexities of distributed data with CockroachDB, eliminating manual operations and complicated configurations while ensuring optimal performance. All so they, and you, can spend time focusing on what matters: your customers.

Learn the three ways to orchestrate stateful apps in Kubernetes, and some of the factors that will help you choose which path is best for your infra.

Learn how to improve your database performance by chasing down problematic queries with SQL EXPLAIN so that you can fix them!

This blog explains how to use the CockroachDB spatial dialect by building two Spring Boot applications including a CLI Dataloader application and a REST API Trajectory service on top of this database with full CRUD functionality.

AllSaints needed to move from their MySQL database setup to something that offered high availability and scalability. They found CockroachDB.

CockroachDB on Kubernetes and the open source Kubernetes Operator [available on GitHub and in the RedHat Marketplace] automate deployment, management, and maintenance of the database.

The popularity of Kubernetes doesn’t mean it’s easy to use in all scenarios. In this blog we explain how to run a database in Kubernetes.

This Node.js and CockroachDB fundamentals course gives hands-on experience with the tools you need to build modern applications.

Kubernetes is the de facto solution for orchestrating distributed applications. And, increasingly, developers are being required to interact with it. So let’s get the tl;dr on what devs need to know about Kubernetes.

Get more insight into and better performance out of your database with a winning combination: CockroachDB and DBmarlin.

Brazilian bank Nubank migrated its credit card authorization service from in-memory storage to CockroachDB to achieve scalable, always-on infrastructure and more efficient operations.

Access to cloud computing and distributed databases has democratized retail technology for every size org. To truly harness this power, though, you need the right application architecture.

Learn about selective encryption and how to encrypt some tables of your database but not others for improved performance in this CockroachDB tutorial.

Optimal Systems needed to store billions of documents in a cloud-based system. With CockroachDB, ElasticSearch, and K8s, they built something amazing.

With ALTER DATABASE ... SURVIVE REGION FAILURE, CockroachDB engineering has transformed the complex, error prone process of deploying and managing a multi-region application.

How we evaluated Splunk vs ELK vs rolling our own when we built logging in a distributed database, how this improves observability for SRE and Security teams.

We are thrilled that EMC and VMWare executive Lorenzo Montesi has joined Cockroach Labs as our Chief Financial Officer. Lorenzo could not have joined our team at a better time, as we continue our rapid growth in the cloud data market.

CockroachDB's REGIONAL BY ROW SQL syntax makes it easy to home data and distribute data across multiple regions. Dig into how REGIONAL BY ROW was implemented, then try the demo.

Database downtime can be a killer. Here are the stories of three huge companies that suffered costly outages, and what they did to eliminate downtime.

CockroachDB’s multi-region capabilities let you manage data across availability zones and regions, to optimize latency and availability. You can now control data latency and availability with a few SQL statements.

In CockroachDB 21.1, we want to make more development teams successful with multi-region clusters. You can now control your data’s latency and availability with just a few declarative SQL statements.

Taking parental leave to welcome a child shouldn't be stressful. Here are some programs we've implemented for Roachers to make that transition a bit easier.

How ZITADEL built a scalable, cloud-native IAM platform that can scale across regions and across clouds.

It is an absolute honor that, after the year we've all had, Cockroach Labs has been named to Inc. Magazine’s annual list of the Best Workplaces for 2021.

When you interview at Cockroach Labs, you get ample interview prep. We believe in fair and equitable interviewing, so we opened our interview process to help candidates succeed.

In this post, we model JSON data in a simple Go app that uses CockroachDB as its datastore. Modeling data with JSON can minimize infrastructure and application complexity.

How Amruta Ranade, Technical Writer turned Developer Advocate, built the skills needed to reinvent her career and used the Cockroach Labs internal mobility program to make the transition.

Spatial data types including GEOMETRY and GEOGRAPHY are available for free in open source, distributed CockroachDB.

Modern fintech apps like Betterment and Robinhood push the limits of what consumers expect from banking apps. They can support real-time decision-making and transaction processing.

Learn practical steps to improve query performance on your applications in the new course offered by Cockroach University.

How does Cockroach Labs view corporate charitable giving? Like a lot of things here, it's a team effort, and one that reflects our employees' values.

What is Kubernetes, anyway? In this article, we'll explain what Kubernetes is and how it works using the film Titanic. I'll never let go... of Helm!

“Not only did we want a database that could work for us when we launched, but we needed a solution that could work for us in the future.” — Josh Stewart, CTO

The original draft of the analysis we presented was reviewed internally, and yet still inaccuracies slipped through. We are a team of humans. We make mistakes. We take full responsibility for the invalid conclusions we published.

Learn how Infinite Colors, our employee resource group for neuro-diverse people, fulfills its mission to share resources about neuro-diversity in the workplace.

Since Rails natively supports popular databases like MySQL and PostgreSQL, it should come as no surprise that it’s just as easy to use CockroachDB with Rails!

Learn the fundamentals of Distributed SQL and practical first steps to get started with CockroachDB in two new courses released on Cockroach University. Courses are free, and include hands-on labs.

For many people, the past year has been straining. Neuro-diverse individuals have been particularly strained, having to balance their differences with all the changes happening around them. This post is collection of voices from Infinite Colors, Cockroach Labs' affinity group for neuro-diverse employees.

Cloud tuning, performance, and benchmarking is no joke. This article digs into three tips for getting the most out of Google Cloud with advice directly from the GCP team.

Migrating from Go dep to Go modules is a complex journey. Read about how CockroachDB did it, gotchas and best practices.

CockroachDB for Java Developers is now available on Cockroach University. You will build a full-stack ride-sharing application in Java using Spring Boot with Spring Data JPA and CockroachDB.

Our Technical Campus Recruiter shares what makes internships at Cockroach Labs unique.

In this post, we investigate how banks and other financial institutions can deliver peak performance while ensuring compliance with local data protection and privacy laws.

Payment solutions data architecture in production with CockroachDB and Kubernetes.

CREWS (Cockroach Employees Who Support) are our employee support groups, and one small part of how we create an inclusive environment at Cockroach Labs.

A group of York University students set out to fix problems with finding mentors. Their app is built with Vue.js, Firebase, and CockroachDB and uses an advanced matching algorithm to get the best fit between mentors and mentees.

It is our responsibility to financially support the open source developers and maintainers who help us build an ecosystem of tools and libraries that work with CockroachDB. We proudly sponsor projects and maintainers.

Many databases claim to be "global." If you are evaluating products that promise global capabilities — like CockroachDB or Amazon Aurora — they should have these three requirements.

Batch data sucks — it's slow, manual, cumbersome, and often stale. That's why we moved from batch uploading our telemetry data to streaming this data with S3, Snowflake, and Looker.

Take a look at this IoT (smart electronics) use case in production on CockroachDB today — none of these electronics will ever go down like a Roomba.

Cockroach Labs is hiring people to work on CockroachDB from Sydney, Australia! If you're curious about me -- the lone Aussie -- my journey, and why I'm at Cockroach, read on.

We redesigned the CockroachDB docs site to improve its functionality and digital accessibility, and to make our site easier for users to complete interactive tutorials.

POC@CRL is an employee-driven community focused on promoting professional and personal development and belonging for all people at Cockroach Labs.

Banks have different infrastructure requirements than most companies currently in the process of modernizing their tech stack. The stakes are higher, and the transaction environment can be highly complex.

A German startup developed an open source application to for contact tracing COVID-19. They built their platform on CockroachDB because they wanted a performant app that had the ability to scale to new regions.

GitHub stars are a simple way for GitHub users to bookmark repositories that interest them. "Stargazers" is a tool to query GitHub for information about the stars.

This is the story of UNIwise, an education tech company, that powers an online testing platform for universities shut down during the pandemic. As demand surged, they delivered a frictionless experience to universities with a platform built on CockroachDB and Kubernetes.

CockroachDB 20.2's increasingly rich SQL feature set includes support for spatial data, materialized views, Enums, ALTER TABLE, and user-defined schema changes.

Why does a resilient database need Backup and Restore features? Learn about new Backup and Restore capabilities in CockroachDB — including the move to open source.

As long as you're willing to follow the rules, deploying on Kubernetes and traveling by plane can be quite pleasant. But if you want to fly with your alligator or scale a database that must remain available, Kubernetes gets a bit more complicated.

A global financial data firm migrated off legacy Oracle infrastructure, creating a hybrid deployment of CockroachDB that spans on-prem datacenters and Google Cloud.

Python, distributed SQL, and high availability in one package. CockroachDB is an "ORM database" that supports many familiar third-party tools like Pony ORM.

In distributed systems, query troubleshooting gets messy. That's why we introduced distributed tracing and enhanced performance monitoring to CockroachDB.

Connect and Contribute Days are a company-dedicated time for staff at Cockroach Labs to learn, seek understanding, volunteer, and make positive change.

CockroachDB's Console makes troubleshooting runaway queries and slow transactions easier with cluster data including Metrics, Databases, Sessions, Transactions, Statements, and more.

As we settle into the New Year, we are eyeing the goals we need to achieve in the next 12 months. For retailers, how will you obtain new customers this year? How will you scale to a broader audience?

We hosted several interns over the year across various engineering teams, all working on projects deserving of full-length blog posts. Today, however, we'll highlight two projects from our most recent batch and give a briefer treatment for the remaining.

A Q&A with CEO Spencer Kimball about what GDPR compliance means for companies and how the process can be made easier using CockroachDB.

CockroachDB supports some of the most data-sensitive industries including healthcare and finance. CockroachDB protects sensitive data by redacting it data out of log files and crash reports.

Now in its third year, the 2021 Cloud Report compares AWS, Azure, and Google (GCP) to tell realistic performance stories on behalf of mission-critical OLTP applications.

With our team working from home these past months, we’ve had to think creatively on how to foster learning opportunities on our Engineering team, specifically: when you first join the company and day-to-day learning from each other.

Take a look at the database on demand project that Bose is building to modernize their tech stack and bring cloud-connected experiences to all their devices.

We are proud to announce a new round of funding at a milestone valuation, which recognizes our rapid growth, happy customers, and emerging role as a leading cloud-native SQL database.

After a major network outage knocked its customer services app offline, a top U.S. cable company replaced Amazon Aurora with CockroachDB to provide an always-on customer service experience.

Support for spatial data and geospatial indexing was one of the most requested features in the history of CockroachDB. As of CockroachDB version 20.2, we launched support for scalable spatial data and indexing.

Throughout our journey, our open source community has made valuable contributions to CockroachDB. This year, we had over 180 commits from over 65 contributors. Thank you.

CockroachDB 20.2 performs 40% better on TPC-C, the industry-standard OLTP benchmark, passing 140K warehouses with a maximum throughput of 1.7M transactions per minute (tpmC).

Spatial data and indexing is a fundamental feature in many of the most popular applications. This blog explains what spatial data is and what the spatial data types are.

I’m a database nerd. Or, to be more precise, a DBMS nerd. But back in university, I avoided the Databases course at all costs.

Hacktoberfest 2020 created 60+ first-time open source contributors who built 29 CockroachDB apps and contributed 33 docs improvements.

Distributed BACKUPs and RESTORE are now in CockroachDB Core to provide reliable, valuable Disaster Recovery for all CockroachDB applications.

CockroachDB 20.2 includes spatial data types and indexing, improved performance on TPC-C and TPC-H benchmarks, and introduces CockroachDB on Kubernetes. All available in CockroachDB Core.

Financial services leader JPMorgan Chase inducts CockroachDB into Hall of Innovation in recognition of our next-generation data infrastructure.

CockroachDB and CockroachDB Dedicated have a full suite of security capabilities baked in. From TLS connections to encrypted backup/restore and RBAC controls for your data, we’ve worked hard to make sure you can secure your data and your workloads.

Jim Walker chats with Red Hat principal product manager Scott McCarty about everything from the future of serverless and distroless, to what happens when you run Oracle on Kubernetes.

This blog walks through why topology patterns matter in CockroachDB, and how to select the one that works best for your use case.

Are enterprises adopting the DBaaS model? And which DBaaS vendors best suit enterprise workloads? GigaOm's Radar Report answers these questions, and more.

Is CockroachDB a distributed SQL database, or a distributed key value store? Learn about how the kv storage system in CockroachDB enables distributed SQL.

Last year the BulkIO team at Cockroach Labs replaced the implementation of our IMPORT bulk-loading feature with a simpler and faster data ingestion pipeline. In most of our tests, it looked like a major improvement: the release notes for CockroachDB v19.2 touted "4x faster" IMPORT.

In this blog post, we'll highlight MyMahi’s application architecture and discuss how serverless technologies like AWS Lambda interact with CockroachDB.

Cockroach Labs is proud to participate in DigitalOcean’s Hacktoberfest 2020, a celebration of open source and community innovation.

Simulate a CockroachDB cluster on localhost with Docker! A simulated CockroachDB cluster makes for easy testing, training, and development work.

Build a Go app with upper/db and Cockroach! upper/db gives you tools for the most common operations with databases, and is now compatible with CockroachDB.

CockroachDB for Python Developers is a new course for developers looking to build scalable, resilient apps on CockroachDB and Python.

How we built a persistence layer with CockroachDB and Hibernate. CockroachDB's PostgreSQL compatibility made this a smooth experience.

The CockroachDB dialect for Hibernate is officially available 🥳 Hibernate now offers first-class support for CockroachDB, so get building in Java and CRDB.

Pebble is a RocksDB-inspired, and RocksDB compatible, key-value store written in Go that brings greater stability to CockroachDB.

In this blog post, we’ll recap lessons we've learned while scaling our SaaS product, CockroachDB Dedicated, with Kubernetes implementation patterns.

SQL vs. NoSQL? New research from DZone's Database Trends Report indicates more companies are choosing a mix of both for their big data needs.

Database consistency models and isolation levels are often overlooked--but they have massive implications on security, performance, data correctness.