CockroachDB vs GCP Postgres: Consistency

Description

Our Technical Evangelist Rob Reid has been comparing Distributed SQL Database CockroachDB against a number of databases to understand the differences in consistency. In this video, he takes a look at GCP Postgres. Watch the full video to understand what the code looks like in GCP Postgres and to see how it directly compares to CockroachDB. 00:00 Introduction 00:20 Up close with the code for GCP Postgres 00:39 Write and read URLs (Primary instance in GCP Postgres and Read Replica) 01:05 Creating a Go channel and kicking off a read and write thread 01:23 A function that writes to Postgres 01:37 A read function 01:53 How CockroachDB compares to GCP Postgres: a side by side test 02:18 Why the replica was in an inconsistent to the primary instance in GCP Postgres 02:35 The limitations of cloud augmented legacy databases such as AWS Aurora, GCP AlloyDB, GCP Postgres, and Azure Cosmos DB 02:57 The limitations of eventual consistency for finance, ecommerce, or inventory management 03:07 Strong consistency in CockroachDB #CockroachDB #Postgres #Postgresql #GCP #DistributedSQL