A Smooth Sea Never Made a Skillful Sailor

This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're auditing schema change events, configure Linode Cloud Storage for CockroachDB bulk ops, and lots of DBeaver goodness. Previous articles Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Volume 8 Volume 9 Topics Topic 1: Capture schema change history Topic 2: Use Linode Object Storage for CockroachDB bulk ops Topic 3: Configure DBeaver for CockroachDB Serverless Topic 4: Configure DBeaver for multiple databases Topic 5: Configure DBeaver CockroachDB connection with pgpass Topic 1: Capture schema change history There was a question in our community Slack on capturing schema changes from a cluster. CockroachDB has a system.eventlog table that can be inspected for audit events like schema changes, cluster configuration changes, user and role changes, etc. This table is a running record of these events and by default it retai...

This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're covering how to generate workload data for CockroachDB for offline use, decode hex data into human-readable form, show all K/V pairs within the requested range, leverage pgpass utility with cockroach binary and getting table and database size in cockroach CLI. Previous articles Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Volume 8 Topics Topic 1: Generate workload data Topic 2: Convert hex keys to human-readable form Topic 3: Show all K/V pairs within the requested range Topic 4: Using pgpass with the cockroach binary Topic 5: Get table size from CLI Topic 1: Generate workload data The standard approach to generate workload data, say for tpcc workload has always been the following cockroach workload init tpcc "postgresql://user:password@127.0.0.1:26257?sslmode=require" This will generate the sample data a...