Artem Ervits dbist

## cockroachdb-pgcat-high-availability.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dbist
                / cockroachdb-pgcat-high-availability.md
            
            
              Last active
              April 24, 2023 18:53
            
          
    Connection pool high availability with CockroachDB and PgCat


I've been experimenting with PgCat which markets itself as a PostgreSQL pooler and proxy (like PgBouncer) with support for sharding, load balancing, failover and mirroring.

I've written about PgCat and CockroachDB in my previous article


## cockroachdb-apache-pulsar.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dbist
                / cockroachdb-apache-pulsar.md
            
            
              Last active
              April 11, 2023 14:33
            
          
    Using CockroachDB CDC with Apache Pulsar


As of this writing, CockroachDB does not have a direct integration with Apache Pulsar and this tutorial is an attempt to integrate CockroachDB CDC with Pulsar via our existing Kafka sink.

Previous articles on CockroachDB CDC


## crdb-til12.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dbist
                / crdb-til12.md
            
            
              Last active
              April 20, 2023 18:12
            
          
    CockroachDB TIL: Volume 12


This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're finding partial indexes, identifying the DB Console URL with SQL, experimenting with a light weight pooler called pgcat, handling client disconnects and improving UX with PGSERVICEFILE

Previous articles


## cockroachdb-rbr.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dbist
                / cockroachdb-rbr.md
            
            
              Last active
              March 7, 2023 20:01
            
          
    Correcting my misconceptions with REGIONAL BY ROW tables


This tutorial will dive deeper into nuances with CockroachDB REGIONAL BY ROW tables. I learned the hard way about the limitations and to pay close attention to the documentation on the topic.

Previous articles on multiregion


## cockroachdb-pgbench3.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dbist
                / cockroachdb-pgbench3.md
            
            
              Last active
              December 29, 2022 15:52
            
          
    Optimizing pgbench for CockroachDB Part 2


I originally wrote an article on pgbench and CockroachDB in October of 2021. Today, I am going to continue talking about pgbench optimizations you can implement to make CockroachDB perform.

Previous articles


## cockroachdb-pgbench2.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dbist
                / cockroachdb-pgbench2.md
            
            
              Last active
              December 29, 2022 15:35
            
          
    Optimizing pgbench for CockroachDB Part 1


I originally wrote an article on pgbench and CockroachDB in October of 2021. Today, we're going to return to the topic and discuss a few improvements.

Previous articles


## crdb-sso-python.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dbist
                / crdb-sso-python.md
            
            
              Last active
              October 27, 2022 20:23
            
          
    Using short-lived tokens to authenticate Python applications to CockroachDB


Today we're going to demonstrate how a Python application can interact with CockroachDB using jwt tokens. We are going to go over requesting and renewing authentication tokens.

Motivation


## crdb-sso-cli.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dbist
                / crdb-sso-cli.md
            
            
              Last active
              October 26, 2022 18:42
            
          
    Configure Single Sign On for CockroachDB CLI with Okta IdP


Today we're going to cover how to set up Single Sign On for CockroachDB CLI with Okta SSO.

Motivation


## crdb-til11.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dbist
                / crdb-til11.md
            
            
              Last active
              December 23, 2022 17:11
            
          
    CockroachDB TIL: Volume 11


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


## crdb-til10.md

      
              1 file
            
          
              0 forks
            
          
                0 comments
              
            
              0 stars
            
          
                dbist
                / crdb-til10.md
            
            
              Last active
              October 18, 2022 16:45
            
          
    CockroachDB TIL: Volume 10


This is my series of articles covering short "Today I learned" topics as I work with CockroachDB. Today, we're covering ULID and UUID generation, tab completion in the CLI, third-party IDEs like Postico and Serverless clusters, capability to shave the prescious milliseconds and remove unnecessary network hops, make follower reads more useful in application code and as always improve your security posture.

Previous articles