CockroachDB Videos
← Back to all videos

Introduction to LTREE | CockroachDB

2025-12-17

Demos & Tutorials

Description

Rob Reid provides an introduction to LTREE (label tree) in CockroachDB, a data type used to represent hierarchical data without needing complex recursive queries. LTREE can be used for various types of hierarchical data, including bill of material data, product categorization data, geographic hierarchies, and permissions data. 00:00 Intro to LTREE 00:26 Examples of data that can be stored using LTREE 00:36 Using LTREE for permissions data 03:10 Using LTREE for product categorization 04:18 Using LTREE for geographic hierarchical data 07:27 Conclusion #distributedsql #database Learn more: https://www.cockroachlabs.com/docs/stable/ltree