Search for a command to run...
Articles tagged with #cockroachdb
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...