---
title: "Michael Goddard (@linuxologist) | Hashnode"
description: "I love CockroachDB. Read the latest articles by Michael Goddard on Hashnode."
url: "https://hashnode.com/@linuxologist"
---

@linuxologist

# Michael Goddard

@linuxologist · Joined February 2021

I love CockroachDB

### [Good Enough Text Search](https://goddard.hashnode.dev/good-enough-text-search?utm_source=hashnode&utm_medium=feed)

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:/...

7 min read · [goddard.hashnode.dev](https://goddard.hashnode.dev/good-enough-text-search?utm_source=hashnode&utm_medium=feed)

[May 18, 2023](https://hashnode.com/posts/good-enough-text-search/64666e984b02be7a340f7b4c)

### [Use Cases for Trigram Indexes (When it's Okay not to use Full Text Search)](https://goddard.hashnode.dev/use-cases-for-trigram-indexes-when-its-okay-not-to-use-full-text-search?utm_source=hashnode&utm_medium=feed)

Or, "Finding Q-Tortas"

8 min read · [goddard.hashnode.dev](https://goddard.hashnode.dev/use-cases-for-trigram-indexes-when-its-okay-not-to-use-full-text-search?utm_source=hashnode&utm_medium=feed)

[Dec 12, 2022](https://hashnode.com/posts/use-cases-for-trigram-indexes-when-its-okay-not-to-use-full-text-search/63975cb0c0f7dadc67cf26aa)

### [Thinking about the Outbox Pattern and CockroachDB](https://goddard.hashnode.dev/thinking-about-the-outbox-pattern-and-cockroachdb?utm_source=hashnode&utm_medium=feed)

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 ...

3 min read · [goddard.hashnode.dev](https://goddard.hashnode.dev/thinking-about-the-outbox-pattern-and-cockroachdb?utm_source=hashnode&utm_medium=feed)

[Sep 23, 2022](https://hashnode.com/posts/thinking-about-the-outbox-pattern-and-cockroachdb/632dc7593ac18d0d78a00560)

### [CockroachDB Changefeeds: mapping primary key to Kafka partition](https://goddard.hashnode.dev/cockroachdb-changefeeds-mapping-primary-key-to-kafka-partition?utm_source=hashnode&utm_medium=feed)

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...

3 min read · [goddard.hashnode.dev](https://goddard.hashnode.dev/cockroachdb-changefeeds-mapping-primary-key-to-kafka-partition?utm_source=hashnode&utm_medium=feed)

[Sep 19, 2022](https://hashnode.com/posts/cockroachdb-changefeeds-mapping-primary-key-to-kafka-partition/6328a215195e7dc741da6145)

### [CockroachDB: An Experiment With on Disk Encryption](https://goddard.hashnode.dev/cockroachdb-an-experiment-with-on-disk-encryption?utm_source=hashnode&utm_medium=feed)

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...

4 min read · [goddard.hashnode.dev](https://goddard.hashnode.dev/cockroachdb-an-experiment-with-on-disk-encryption?utm_source=hashnode&utm_medium=feed)

[1](https://hashnode.com/posts/cockroachdb-an-experiment-with-on-disk-encryption/61ddb8c944f1964f4fa7d6b2) [Jan 11, 2022](https://hashnode.com/posts/cockroachdb-an-experiment-with-on-disk-encryption/61ddb8c944f1964f4fa7d6b2)
