How We Built a CockroachDB Dialect for Hibernate
Jordan Lewis, Nathan VanBenschoten and Charlotte Dillon
The CockroachDB dialect for Hibernate is officially available 🥳 Hibernate now offers first-class support for CockroachDB, so get building in Java and CRDB.
Introducing Pebble: A RocksDB Inspired Key-Value Store Written in Go
Peter Mattis
Today we’re introducing Pebble, a RocksDB-inspired and RocksDB compatible key-value store written in Go that brings greater stability to CockroachDB.
Alter Column Types Without Taking Tables Offline
Richard Cai
Database schema design is difficult. Requirements evolve, and somtimes columns have to change types. CockroachDB enables ALTER COLUMN TYPE without taking tables offline.
Using Lateral Joins for Business Analytics in CockroachDB 20.1
Andy Woods
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.
Nested Transactions in CockroachDB 20.1
Raphael 'kena' Poss
What do nested transactions look like in an ACID environment? We explore the journey of a nested SQL transaction in CockroachDB in this post.
SIGMOD 2020: Cockroach Labs Publishes Research Paper on CockroachDB
Jessica Edwards
"CockroachDB: The Resilient Geo-Distributed SQL Database," a research paper codifying years of research on CockroachDB, will be shared at ACM SIGMOD 2020.
How Online Primary Key Changes Work in CockroachDB
Rohan Yadav
As of our 20.1 release, CockroachDB supports online primary key changes. This means that it's now possible to change the primary key of a table while performing read and write operations on the table. In this blog, we'll review how data is stored in CockroachDB and how we overcame technical challenges involved in getting online schema changes to work in CockroachDB.
Time and Related Data Types in PostgreSQL
Oliver Tan
We here at Cockroach Labs have been busy getting CockroachDB (CRDB) more in line with PostgreSQL for v20.1. This allows you to be able to use Cockroach as a drop-in replacement for PostgreSQL (whilst using your favourite existing ORM or driver), but with the powerful, scalable backend we provide. Time, Timestamp and TimestampTZ have been three data types Cockroach has supported, but were not well matched with PostgreSQL functionality. We were also missing the TimeTZ datatype, as well as precision…
Announcing CockroachDB 20.1: New Features Let You Build Fast and Build to Last
The Cockroach Labs Team
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.
Living Without Atomic Clocks
Spencer Kimball and Irfan Sharif
If someone knows even a little about Spanner, the first question they have is: "How does CockroachDB provide external consistency without atomic clocks?"