Skip to content

Instantly share code, notes, and snippets.

View dbist's full-sized avatar

Artem Ervits dbist

View GitHub Profile

Using CockroachDB CDC with Confluent Cloud Kafka and Schema Registry


I was working on a demo requiring data to be serialized in Avro format. CockroachDB supports Avro for change data capture when used in conjunction with Confluent Schema Registry. We have documentation on CDC with Avro using a local Schema Registry but what is missing is hosted Schema Registry on Confluent Cloud. We are going to address that in the short term but in the meantime, this tutorial should suffice.


Check out my previous articles on CDC

SaaS Galore: Integrating CockroachDB with Confluent Kafka, FiveTran and Snowflake


This tutorial is meant to demonstrate how CockroachDB Change Data Capture can be integrated with a rich third party ecosystem of products to build sophisticated data pipelines.


Motivation

CockroachDB TIL: Volume 7


This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're covering CLI query stats, clone schemas quickly, distinguish which table IDs correspond to which table names, connect to non-default databases and copy columns between column families.


Previous articles

Configure Single Sign On for CockroachDB Dedicated DB Console with Microsoft identity platform and OpenID


Today we're going to cover how to set up Single Sign-on for CockroachDB Dedicated cluster using Microsoft Identity Platform.


Motivation

CockroachDB TIL: Volume 6


This is my series of articles covering short "Today I learned" topics as I work with CockroachDB.


Previous articles

Using a custom CockroachDB image with Docker and Kubernetes


Here's a scenario. A highly regulated organization wants to use a custom CockroachDB image because the default CockroachDB image uses Red Hat UBI base image which does not meet the security standards this organization demands. Today, we're going to cover how to build a custom image based on CockroachDB which then can be used in container orchestration of choice.


Motivation

Using CockroachDB workload with Kerberos


GSSAPI authentication is becoming increasingly popular as CockroachDB starting to make inroads in Fortune 2000 customer bases and financial services segment. That said, ecosystem coverage for GSS needs to improve for parity with other authN methods. Today, we are providing a workaround and a look at the future. By the way, do you realize this is my 15th article on Kerberos and CockroachDB?


Articles covering CockroachDB and Kerberos

Configure Single Sign On for CockroachDB Dedicated DB Console with Okta


Today we're going to cover how to set up Single Sign-on for CockroachDB Dedicated cluster with Okta SSO.


Motivation

Configure Single Sign On for CockroachDB Dedicated DB Console with Google OAuth


Today we're going to cover how to set up Single Sign-on for CockroachDB Dedicated cluster.


Motivation

Using Azure Load Balancer with CockroachDB


Today we're going to set up Azure Load Balancer service with CockroachDB. I had a customer setting up CockroachDB on IaaS and one of the choices we had to make was use HAProxy or use Azure Load Balancer. Our docs have a note on it but the details are left for the reader. Today, I attempt to fill in the blanks.


Motivation