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