MGMichael Goddardingoddard.hashnode.dev·May 18, 2023 · 7 min readGood Enough Text SearchWith 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:/...00
MGMichael Goddardingoddard.hashnode.dev·Dec 12, 2022 · 8 min readUse Cases for Trigram Indexes (When it's Okay not to use Full Text Search)We've been planning a visit to Orange County, California, where I grew up, over the upcoming holidays. My favorite Mexican restaurant is there, in Placentia: Q-Tortas! I have frequent cravings for their carnitas burrito, so a visit there is obligator...00
MGMichael Goddardingoddard.hashnode.dev·Sep 23, 2022 · 3 min readThinking about the Outbox Pattern and CockroachDBMotivation 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 ...00
MGMichael Goddardingoddard.hashnode.dev·Sep 19, 2022 · 3 min readCockroachDB Changefeeds: mapping primary key to Kafka partitionIn 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...00
MGMichael Goddardingoddard.hashnode.dev·Jan 11, 2022 · 4 min readCockroachDB: An Experiment With on Disk EncryptionWhen 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...01A
