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

*This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're covering Previous articles Volume 1 Volume 2 Volume 3 Volume 4 Volume 5 Volume 6 Volume 7 Volume 8 Volume 9 Volume 10 Topics Topic 1: [Generating ULID strings in CockroachDB](#Topic 1: Generating ULID strings in CockroachDB) Topic 2: Enable CLI tab completion for column names Topic 1: Generating ULID strings in CockroachDB CockroachDB adopted ULID several releases ago as yet another version of UUID type. There is no explicity ULID type in CockroachDB. There are functions available to generate ULID in UUID format. So in case you need to generate lexicographically sortable IDs, you can use the built-in gen_random_ulid() function and there are a several conversion functions to convent from ULID to UUID i.e. ulid_to_uuid and vice versa, i.e. uuid_to_ulid . One point of friction in CockroachDB exists where one needs to generate an actua...