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.
Intern Archer Zhang writes about the improvements he made to the algorithm behind the unordered distinct operator in our vectorized SQL engine.
Startup companies, like TuneGO, use CockroachDB to build from the beginning for scale, resilience, and Kubernetes compatibility.
Director of Product Marketing Jim Walker sat down with Keith McClellan, one of Cockroach’s Solutions Engineers, to chat about the storage and data challenges that you’ll encounter deploying Kubernetes, and how running it with CockroachDB can simplify those challenges.
In this post, we provide a top-down explanation of how we added disk spilling to the vectorized execution engine, starting with a description of on-disk algorithms for different types of queries, and ending with a description of the single building block that all of these algorithms use.
Oracle has historically been the database for healthcare, but times have changed. Read why one healthcare provider is moving workloads to CockroachDB.
CockroachDB 20.1 simplifies the handling of client-side transaction retry errors by enabling SELECT FOR UPDATE. Learn more about what that means for transaction latency and throughput in this feature demo blog.
What do nested transactions look like in an ACID environment? We explore the journey of a nested SQL transaction in CockroachDB in this post.
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.