engineering

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

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

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.

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.

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