Terror free online schema changes | How to change your Foreign Keys

Description

You can perform terror free online schema changes with CockroachDB and in this demo you'll learn how to change your foreign keys. You can see these steps in the corresponding blog as well: https://www.cockroachlabs.com/blog/online-schema-changes-in-cockroachdb/ No downtime. No full table scans. 00:00 Looking at foreign key constraints 00:12 Create the database and tables using Cockroach demo 00:41 Insert data using benthos 1:12 Start a Go application 1:24 How to change the primary key without downtime 2:04 How to introduce a foreign key without downtime 2:45 Run an EXPLAIN on the table to see that there are no full table scans #cockroachdb #distributedsql What is a Foreign Key (with SQL Examples): https://www.cockroachlabs.com/blog/what-is-a-foreign-key/ 3 common foreign key mistakes: https://www.cockroachlabs.com/blog/common-foreign-key-mistakes/