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 CLI query stats, clone schemas quickly, distinguish which table IDs correspond to which table names, connect to non-default databases and copy columns between column families. Previous articles Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Topics Topic 1: SHOW LAST QUERY STATISTICS Topic 2: Clone table definitions in bulk across schemas Topic 3: Quick way to map a table name to a table ID Topic 4: Changing default database for sql client Topic 5: Quick way to move a column from one Column Family to another Topic 1: SHOW LAST QUERY STATISTICS CockroachDB has a very user-friendly and helpful UI called DB Console. I like to refer to it when I debug query performance. We have a very useful Statements page which shows a statement overview, explain plan and execution stats. Little did I know CockroachDB has an und...