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 diagnosing cert issues, looking at client verification of server certificates differences in the cockroach and the psql clients, and checking the node and the CA certificate expiration programmatically. Previous articles Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Volume 8 Volume 9 Volume 10 Volume 11 Volume 12 Topics Topic 1: Diagnose certificate based authentication Topic 2: Differences between cockroach and psql clients for client verification of server certificates Topic 3: Capture the node and the CA certificate expiration programmatically Topic 4: Check the client certificate expiration Topic 1: Diagnose certificate based authentication I was using CockroachDB Serverless with a product called PolyScale.ai for an article I was writing and I've run into a strange issue with certificate-based authN. ...

This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're covering auto-completion and syntax highlighting in CLI with pgcli, Sqlalchemy and ON UPDATE expressions, identifying sessions, naming transaction blocks and setting traces in CLI. Previous articles Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Volume 8 Volume 9 Volume 10 Volume 11 Topics Topic 1: Using pgcli with CockroachDB Topic 2: Using ON UPDATE expression with Sqlachemy Topic 3: Identify current session's transaction ID Topic 4: Identifying and naming transaction blocks Topic 5: Set trace for individual statements in CLI Topic 1: Using pgcli with CockroachDB I've stumbled on pgcli When I was writing my auto-completion topic from the last volume . I originally needed a CLI tool with auto-completion because I desperately needed it to deal with very long schema and table names. When I first tried it wit...