Cockroach Labs Blog

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.

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.

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

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.

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

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.

How we built logging in a distributed database, how that same system improves observability for the SRE and Security team, and how we evaluated Splunk vs ELK vs rolling our own.

This blog defines RPO (Recovery Point Objective), explains how RPO affects business and lays out a solution for building fault-tolerant applications in which data is never lost. Learn more from the blog.

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.

In running benchmarks for the 2021 Cloud Report, we made some accidental discoveries about performance of the major CPU processors: Intel vs AMD vs Amazon's Graviton2.

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.

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

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.

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.

“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

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.

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.

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.

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.

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.

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.

Banks have different infrastructure requirements than most companies undergoing a digital transformation. 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.

This post looks at three solution paths for orchestrating stateful apps in Kubernetes, and walks through some of the factors that might help a dev team choose between them.

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.

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

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.

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?

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.

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.

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.

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?

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

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.

CockroachDB and CockroachCloud 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.

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?

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.

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

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

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

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

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

Three new tutorials are available for CockroachDB and Spring data access patterns: Spring Data JDBC, Spring Data JPA, and MyBatis.

We’re excited to announce a few updates to our integration that make CockroachDB's compatibility with SQLAlchemy even more seamless.

What are the ins and outs of Distributed SQL? And how does it delivers the capabilities that traditional relational databases simply can't?

The end of the US/EU Privacy Shield agreement is just one piece of the evolving data compliance regulatory landscape. Here's how CockroachDB can help.

Lateral joins - similar to nested foreign loops - are a type of correlated subquery that allow data sources to reference columns provided by previous data sources in the same query. Give them a spin in CockroachDB.

Startup companies, like TuneGO, use CockroachDB to build from the beginning for scale, resilience, and Kubernetes compatibility.

CockroachDB is fully compatibile with Active Record, the ORM powering Ruby on Rails, a popular open-source development frameworks for web apps.

Online Primary Key Changes allows you to upgrade your application from a single-region to multi-region with zero downtime. Here's how to make the most of the feature.

Learn CockroachDB for free with Cockroach University, and preview our upcoming course: "CockroachDB for Python Developers."

We want to give you a database that allows you to quickly and simply build and manage data-intensive applications in the cloud—without worrying about the performance, scale or resilience of those apps. To support that mission, our latest release includes updates that let you build fast and build to last.

In a reflection of our continued growth, we’ve closed $87 million in a series D financing round co-led by Altimeter Capital and Bond Capital.

Duplicate Indexes improve application performance by allowing you to keep data close to users no matter where they are in the world.

With GORM for CockroachDB, Golang developers can access the power of SQL and easily manage database interactions and operations, all in one place.

How we built native support for hash sharded indexes in CockroachDB, which can significantly improve performance on sequential workloads.

As of jOOQ's 3.13.0 release, jOOQ fully supports CockroachDB. The CockroachDB SQL dialect is now fully supported for future jOOQ and CockroachDB versions.

Former intern Georgia Hong writes about the improvements she made to CockroachDB to make importing data without an external service even easier.

Want to use CockroachDB behind your Django app? Learn how in this tutorial by one of our very own customer success engineers.

Python + Distributed SQL, made easy. Today, we’re excited to announce CockroachDB backend support for the Django ORM.

Yugabyte frequently compares themselves to CockroachDB. We investigated their claims. This is our analysis of CockroachDB vs. Yugabyte v2.0.0.

CockroachDB has successfully passed the TPC-C benchmark at 100,000 warehouses. And with a max throughput of 1.2m tpmC, CockroachDB can now process 100X the throughput of Amazon Aurora’s last published benchmark.

CockroachDB 19.2 improves latency, reliability, and usability. We’re bringing the speed of distributed transactions closer to the theoretical minimum.

Announcing CockroachCloud, a self-service, managed cloud offering of CockroachDB. CockroachCloud makes distributed SQL effortless, from small applications to global applications.

Migrate from Oracle to CockroachDB with this step-by-step guide.

Our CockroachDB Feature of the Week, core changefeeds, is a new way for event-driven apps to consume data from CockroachDB.

In this post, we explore the steps we've taken so far--and plan to take--to improve the CockroachDB cost-based optimizer through query caching.

How a vectorized (column by column instead of row by row) approach to merge joins led to a 3x improvement in standard merge joins in CockroachDB.

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.

The realities of building open source software have changed. Today, we're relicensing CockroachDB with a committment to building an open core product.

One small step for Cockroach Labs, one giant leap for our release numbering.

In CockroachDB 2.1, we’ve made it easier than ever to migrate from MySQL and Postgres, improved our scalability on transactional workloads by 5x, and launched a managed offering to help teams deploy low-latency, multi-region clusters with minimal operator overhead.

We’re pleased to announce the availability of Managed CockroachDB, the fully hosted and fully managed service run by Cockroach Labs that makes deploying, scaling, and managing effortless.

The perennial question of homo sapiens is, 'How did we get here?' Today we're going to take a crack at answering that: where 'here' is defined as 'high availability for web services'.

CockroachDB was so named because of its ability to survive failures. In this post, we will cover architectural considerations when building high availability services on top of CockroachDB.

Managing state in Kubernetes is difficult because the system’s dynamism is too chaotic for most databases to handle; especially SQL databases that offer strong consistency.

Since our 1.0 release, we have been hard at work making CockroachDB 2.0 the database that enables a company’s data layer to evolve with their business -- whether they are in a single datacenter or expanding around the world.

Learn which performance metrics matter, why to demand benchmark TPC-C results under serializable isolation, and how CockroachDB 2.0’s performance compares to 1.1.

With JSON support in CockroachDB, you can now use both structured and semi-structured data within the same database.

With AWS CloudFormation and Kubernetes, developers can automate the setup of multi-node test cluster deployment for the latest stable and alpha CockroachDB features.

This blog post discusses using multi-row DMLs, their performance benefits, and the effect of compounding database and application parallelism.

The combination of secure mode and monitoring provides a user with a solid base on which to build database infrastructure in production with secure deployments.

Users with an existing database may have trouble getting their data into CockroachDB, so we built a new feature that performs high-speed, bulk data import.

Kindred Futures partners with CockroachDB to build next generation of global online gaming platform.

CockroachDB 1.1 includes support for faster migrations from legacy databases, simplified cluster management, and improved performance.

This post is the first in a series on how CockroachDB handles its data and discusses the mechanisms it uses to rebalance and repair.

CockroachDB makes it easier to manage and scale mission-critical data, and DC/OS provides elastic scale, zero downtime, and hassle-free operations.

This demo shows how easy it is to span CockroachDB across cloud platforms and then completely migrate data from one cloud to another with a single command.

ActiveRecord is the ORM that powers Ruby on Rails, one of the most popular web app frameworks. What went into supporting ActiveRecord in CockroachDB?

CockroachDB 1.0 was built to be production-ready with an OLTP use case in mind.

Join the Cockroach Labs founders for an unscripted Q&A about the dirty details building 1.0 and in how they achieve consensus across three co-founders.

Launching CockroachDB 1.0, a production-ready release with distributed SQL and multi-active availability in two tiers: CockroachDB Core and CockroachDB Enterprise.

We recently began looking into what it would take to run CockroachDB on a Raspberry Pi, one of the go-to tools of the modern day computer tinkerer.

We introduced Cockroach Labs last June with a simple yet ambitious mission: Make Data Easy. We are now thrilled to launch CockroachDB beta.