Artem Ervits

[Deactivated] [Suspended]

CORE

Solutions Engineer at Cockroach Labs

Fort Lee, US

Joined Feb 2021

About

‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎ ‎

Stats

Reputation:	2396
Pageviews:	406.6K
Articles:	69
Comments:	2

Expertise

Databases

Articles
Comments

Articles

Secure Schema Migrations With Flyway and CockroachDB Dedicated

In this article, explore a solution to TLS certificate issues and containerized schema migrations with Flyway and CockroachDB.

October 25, 2023

· 2,256 Views · 3 Likes

Emitting Protocol Buffers Using CockroachDB CDC Queries

Follow this demonstration using several recent features to demonstrate the ability to serialize CockroachDB rows to proto and emit via CDC Queries.

September 1, 2023

· 4,788 Views · 1 Like

CockroachDB TIL: Volume 13

Cover topics such as diagnosing cert issues and looking at client verification of server certificate differences in the cockroach and the psql clients.

August 31, 2023

· 2,182 Views · 1 Like

Using DuckDB With CockroachDB

Explore this fun experiment using DuckDB to parse CockroachDB Change Data Capture output and query CockroachDB with DuckDB.

May 21, 2023

· 1,678 Views · 1 Like

Reducing Network Latency and Improving Read Performance With CockroachDB and PolyScale.ai

This tutorial explores how to benefit from lowered latency, increased performance, and reduced infrastructure costs, as well as faster reads in more locations.

May 15, 2023

· 3,606 Views · 5 Likes

Load Balancer High Availability With CockroachDB and HAProxy

CockroachDB relies on a load balancer to provide client fault tolerance. Here, take a look at a load balancer as the single point of failure.

May 7, 2023

· 3,601 Views · 1 Like

Connection Pool High Availability With CockroachDB and PgCat

This article covers pooler high availability working with PgCat to provide a highly available configuration where clients can see multiple connections.

April 25, 2023

· 2,219 Views · 1 Like

CockroachDB TIL: Volume 12

Learn to find partial indexes, identify the DB Console URL with SQL, experiment with a lightweight pooler called pgcat, handle client disconnects, and more.

April 20, 2023

· 3,201 Views · 1 Like

Using CockroachDB CDC With Apache Pulsar

As of this writing, CockroachDB does not have a direct integration with Apache Pulsar. Here, integrate CockroachDB CDC with Pulsar via the existing Kafka sink.

April 12, 2023

· 7,932 Views · 3 Likes

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.

March 7, 2023

· 4,086 Views · 1 Like

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.

Updated December 30, 2022

· 3,697 Views · 1 Like

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.

Updated December 30, 2022

· 3,589 Views · 1 Like

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.

December 27, 2022

· 2,822 Views · 1 Like

Using Short-Lived Tokens To Authenticate Python Applications to CockroachDB

JWT tokens can replace passwords for a safer and more secure cloud-native future. Follow this tutorial to get JWT AuthN working with your Python application.

October 28, 2022

· 9,765 Views · 1 Like

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 using short-lived JWT tokens.

October 25, 2022

· 7,247 Views · 1 Like

CockroachDB TIL: Volume 10

Explore ULID and UUID generation, tab completion in the CLI, third-party IDEs like Postico and Serverless clusters, and more in this "today I learned" post.

October 18, 2022

· 4,578 Views · 1 Like

Using CockroachDB CDC With Azure Event Hubs

This tutorial is an attempt to integrate CockroachDB CDC with Azure Event Hubs via our existing Kafka support.

October 3, 2022

· 4,036 Views · 1 Like

Using CockroachDB Dedicated With Starburst Galaxy

In this article, we're going to look at connecting Starburst Galaxy, a Trino SaaS service running with CockroachDB Dedicated.

September 24, 2022

· 4,273 Views · 1 Like

CockroachDB Multi-Region Abstractions for MongoDB Developers With FerretDB

This is yet another part of an interesting experiment with FerretDB and CockroachDB. This time, we're going to expand on the previous articles by looking at the multi-region capabilities in CockroachDB.

September 21, 2022

· 3,193 Views · 1 Like

Experimenting With Unique Constraints in CockroachDB, MongoDB, and FerretDB

This is an unexpected third part of an interesting experiment with FerretDB and CockroachDB. This time, we're going to expand on the previous article.

September 14, 2022

· 4,250 Views · 2 Likes

Migrating MongoDB Collections to CockroachDB With FerretDB

In part 2 of an experiment with FerretDB and CockroachDB, restore a MongoDB collection into CockroachDB via FerretDB, and expand on previous learnings.

September 13, 2022

· 4,854 Views · 2 Likes

CockroachDB TIL: Volume 9

In this latest "Today I learned" post, audit schema change events, configure Linode Cloud Storage for CockroachDB bulk ops, and lots of DBeaver goodness.

September 1, 2022

· 5,142 Views · 3 Likes

CockroachDB TIL: Volume 8

In this "Today I learned" post, learn how to generate workload data for CockroachDB for offline use, decode hex data into human-readable form, and more.

Updated August 23, 2022

· 5,463 Views · 2 Likes

Using CockroachDB as a Backend for OSS MongoDB Alternative FerretDB

In today's tutorial, we are going to step away from the world of Postgres and production readiness topics and have some NoSQL fun using MongoDB API to persist data in CockroachDB.

August 18, 2022

· 4,050 Views · 2 Likes

CockroachDB TIL: Volume 7

Learn about CLI query stats, cloning schemas quickly, distinguishing which table IDs correspond to which table names, connecting to non-default databases, and copying columns between column families.

June 2, 2022

· 6,202 Views · 2 Likes

Using CockroachDB CDC with Confluent Cloud Kafka and Schema Registry

Follow along in this article as I document the steps required to set up CockroachDB CDC with Confluent Schema Registry.

April 21, 2022

· 3,379 Views · 2 Likes

SaaS Galore: Integrating CockroachDB With Confluent Kafka, Fivetran, and Snowflake

Here, learn how CockroachDB Change Data Capture can be integrated with a rich third-party ecosystem of products to build sophisticated data pipelines.

April 8, 2022

· 4,900 Views · 4 Likes

Using PGBouncer With CockroachDB Serverless

In this second tutorial on CockroachDB and PGBouncer, follow a demonstration on how to run PGBouncer along with Cockroach Cloud free-forever tier database.

April 5, 2022

· 3,744 Views · 3 Likes

CockroachDB TIL: Volume 6

In this post, I cover init containers in compose, optimal schema change, productivity on a local machine, and security changes in Java pertaining to Postgresql.

March 21, 2022

· 3,328 Views · 3 Likes

DNS Gotchas With CockroachDB and GSS-API

In this post, learn the way Cockroach binary connects through GSS-API, see impacts from a recent release on the behavior of the native client, and more.

March 16, 2022

· 2,181 Views · 3 Likes

Comments

Three-Headed Dog Meets Cockroach: CockroachDB With MIT Kerberos

Jul 28, 2021 · Lauren Forbes

thank you, when you work with Kerberos so much, you bound to find humor in it. Feel free to check out my other 12 Kerberos articles. Thank you for your feedback.

Working With Multi-Level JSON in CockroachDB

Jul 28, 2021 · Lauren Forbes

thanks for the feedback, let me know if there's anything you'd like me to expand on