dbist

Integrating Snowflake with Trino

---

In today's discourse, we delve into the intricacies of accessing Snowflake via the Trino project. This article illuminates the seamless integration of Trino with Snowflake, offering a comprehensive analysis of its benefits and implications.

---

Previous articles

dbist

Optimizing pgbench for CockroachDB Part 3

---

This is a long anticipated third article on optimizing pgbench for CockroachDB. I've been wanting to write a follow up ever since I learned about new improvements in the next release of CockroachDB.

---

Previous articles

dbist

Secure schema migrations with Flyway and CockroachDB Dedicated

---

CockroachDB Dedicated comes with TLS enabled by default. At the minimum, a certificate authority is needed to authenticate. A customer was having issues using Flyway and TLS.

---

My previous articles on schema migrations and CockroachDB

Migrating feature toggles with Unleash and CockroachDB

dbist

Emitting Protocol Buffers with CockroachDB CDC Queries

---

As of this writing, CockroachDB does not have official support for protobuf payload as part of change data capture. Today, I am going to demonstrate a feature that may or may not land in CockroachDB proper. The product team is looking into viability of the feature before we can officially support it.

---

Previous articles on CockroachDB CDC

dbist

Using DuckDB with CockroachDB

---

This is a fun experiment using DuckDB to parse CockroachDB Change Data Capture output and querying CockroachDB with DuckDB.

---

---

dbist

CockroachDB TIL: Volume 13

---

This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're diagnosing cert issues, looking at client verification of server certificates differences in the cockroach and the psql clients, and checking the node and the CA certificate expiration programmatically.

---

Previous articles

dbist

Reducing network latency and improving read performance with CockroachDB and PolyScale.ai

---

Today, I am looking at a database caching product called PolyScale.ai.

---

Motivation

dbist

Load balancer high availability with CockroachDB and HAProxy

---

I've been experimenting with CockroachDB high availability scenarios and fault domains. CockroachDB relies on load balancer to provide client fault tolerance. Today, I'd like to look at a load balancer as the single point of failure. To my knowledge, load balancer high availability is not discussed in any of the existing CockroachDB documentation.

---

Checkout my previous article where I discuss connection pool high availability

dbist

Connection pool high availability with CockroachDB and PgCat

---

I've been experimenting with PgCat which markets itself as a PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

---

I've written about PgCat and CockroachDB in my previous article

dbist

Using CockroachDB CDC with Apache Pulsar

---

As of this writing, CockroachDB does not have a direct integration with Apache Pulsar and this tutorial is an attempt to integrate CockroachDB CDC with Pulsar via our existing Kafka sink.

---

Previous articles on CockroachDB CDC