With the release on Tuesday (May 16, 2023) of version 23.1 of CockroachDB, we all get an unanticipated treat: PostgreSQL-compatible full-text indexing and search! As usual, the CockroachDB docs do a fine job of describing this; they are here: https:/...
Or, "Finding Q-Tortas"
Motivation I certainly don't claim to be an expert on the Outbox Pattern but, as I understand it, one key feature is that it involves rows written into a database table which is configured to emit events into a change feed. These rows are ephemeral ...
In the Documentation for CockroachDB changefeeds (CDC), we read that Rows are sharded between Kafka partitions by the row’s primary key. This post documents a simple experiment to verify this claim. This comment from the Go Kafka client used by Coc...
When we hear about our data being encrypted, kept safe from prying eyes, we're reassured. Or, we could be skeptical and seek some empirical proof that the data is indeed encrypted. That's the motivation behind this brief exercise, to show the diffe...
Last week, while running a workload consisting of 200 different queries, we noticed right away that a CPU imbalance was causing a performance issue. Looking at the first graph, below, you can see right away that one of the three CockroachDB nodes wa...
CockroachDB is a relational database which looks very much like PostgreSQL but with the added benefits of horizontal scalability, zero-downtime upgrades, and the ability to survive the loss of a node, an availability zone, or even an entire cloud re...
In today's "Cockroach Hour", Sean from DoorDash was the guest, and it was a really interesting session. At one point he was commenting on the absence of triggers and stored procedures and how that related to their practice of automating the update o...
When running your production workloads on CockroachDB, you'll want to take regular backups. CockroachDB is frequently deployed into a cloud, such as EC2, GCP, or Azure, and these cloud environments consistently offer a highly durable "blob store". ...