CockroachDB Data Types: JSON

Description

Explore the flexibility of JSON and JSONB data types in CockroachDB to efficiently manage structured and semi-structured "documentesque" data. Rob Reid demonstrates how to handle diverse datasets, such as varied international address formats, without the constraints of a rigid relational table structure. 00:00 Intro 00:14 Demo setup 01:05 Table Migration 01:28 Indexing Challenges 01:42 Stored Columns 02:16 Virtual Columns 02:55 Expression Indexing 03:16 Inverted GIN Indexes 03:39 Exploring JSON queries 05:03 Adding and Updating JSON Fields 05:22 Removing Fields 05:30 Miscellaneous Functions 05:51 Row Expansion 06:02 JSON Arrays 06:10 Wrap up #database #distributedsql #cockroachdb Learn more at cockroachlabs.com