Use Cases for Trigram Indexes (When it's Okay not to use Full Text Search)
Or, "Finding Q-Tortas"
Dec 12, 20228 min read48
Command Palette
Search for a command to run...
#sql
Articles tagged with #sql
Thinking about the Outbox Pattern and CockroachDB
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 ...
Sep 23, 20223 min read287CockroachDB Changefeeds: mapping primary key to Kafka partition
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...
Sep 19, 20223 min read81A Contrived Example to Illustrate How to Track "Last Updated Timestamp" in CockroachDB
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...
Mar 4, 20212 min read193Running Apache Airflow using CockroachDB as the meta store: work in progress
Background and Motivation Using CockroachDB as the back end metadata store for Airflow makes sense in environments where downtime, whether unplanned or due to routine maintenance activities (DB software upgrades, schema changes, etc.), is not an opti...
Feb 18, 20214 min read950