A Smooth Sea Never Made a Skillful Sailor

This is a new series of articles covering short "Today I learned" topics as I peel the layers on CockroachDB. This is meant to resemble release notes. I decided to mix it up with the format for these posts as they may not justify an entire blog. Previous articles Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Topics Topic 1 $COCKROACH_URL environment variable to save typing with connection strings Saves typing Can store password instead of passing in the prompt every time Pass additional session parameters instead of retyping them all the time I find myself opening multiple command prompts and accessing the same cluster each time. $COCKROACH_URL is a handy trick to save myself time typing the connection string each time. Let's take CockroachDB Free Tier for example, it comes with a long connection string, which by the way also includes a password. One way to approach this is to save the connection string in an environment variabl...

This is a new series of articles covering short "Today I Learned" topics as I peel the layers of CockroachDB. This is meant to resemble release notes. I decided to mix it up with the format for these posts as they may not justify an entire blog. Previous articles You can find my past articles below Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Topics Topic 1: Unit Testing with CockroachDB Topic 2: Override CockroachDB Cluster ID Topic 3: Sleep command in CockroachDB and PG Topic 4: Set timezone on SQL Client Topic 1: Unit Testing with CockroachDB I get this question a lot, what is the best way to unit test CockroachDB as part of application development. Depending on use case, there are several approaches we can take. There's a venerable cockroach demo , which has been my trusty go-to tool when I needed something in a hurry. It comes with a one hour license for enterprise features, which you can also unit test but it also comes w...

This month I was on a hiatus in terms of blog posts and had to focus on the other parts of my life. Nevertheless, this post was long time coming and I was ambitiously waiting for a quiet time to get this out of the door. Today, I'm talking about CockroachDB and the ever so popular YCSB benchmark suite. Specifically, I'm going to step through the workload A in the YCSB suite of workloads against CockroachDB.

Today, I'm going to demonstrate how easily we can integrate a SQLAlchemy application running against a kerberized CockroachDB cluster. The experience building this appliation was almost too easy.

Today, I'm going to talk about means of using Django with a kerberized CockroachDB and what that entails. This is not uncommon in a production use case and expecting enterprise-grade access to development frameworks is table stakes for some of our customers.