CockroachDB TIL: Volume 8
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...