Skip to main content

Spatial Data Application | Spatial Database | Spatial Data | Spatial Data demo

Spatial data powers some of the world’s most innovative apps and services, letting you answer questions like, “Where’s the nearest gas station?” and “How long will it take for my ride-sharing vehicle to arrive?” and even, “Where can I catch a Pokémon?” And in this video we'll show you how to build a spatial data application. CockroachDB is the first SQL database to build spatial data functionality from the ground up for a distributed environment. This means you can now effortlessly scale your spatial data and have the confidence it will survive outages. In this episode of the Cockroach hour, we will cover: • Geometry and Geography types • Spatial Indexing • PostGIS-compatible built-ins and functions • Complete tech stack for building a spatial data application • Live demo of a rolling upgrade with no downtime 00:00 CockroachDB's decision to build support for Spatial Data 00:36 What is Spatial Data? 1:55 How CockroachDB built support for spatial data 5:50 How to build a spatial data application: Spatial Data Demo of a spatial data app built with Python Flask and CockroachDB 15:00 What data is used to build a spatial application? 15:50 Github repository for all the code used in the spatial data application 16:45 the CockroachDB consul 17:35 Live demo of a rolling upgrade 23:30 Building spatial data support in Go 25:05 How close is the PostGIS library to the CockroachDB spatial data library? 27:12 Is there a benchmark that compares Postgres to CockroachDB? 28:58 The great thing about Spatial Data and Kubernetes - How to scale a spatial data application in CockroachDB 30:28 What is the benefit of running a spatial database on Kubernetes? 33:29 Can a spatial data application on CockroachDB survive region failures? 34:50 Pinning data to a location for low latency 35:55 How do geospatial indexes work? 37:20 Spatial Data is open source 39:15 What applications do people use spatial data for? #SpatialData #SpatialDataApp #SpatialDataDemo #PostGIS #CockroachDB Relevant Links: Distributed Spatial Data: https://www.cockroachlabs.com/blog/spatial-data/ Why is spatial data so special?: https://www.cockroachlabs.com/blog/spatial-data-types/ Glossary of spatial data terms: https://www.cockroachlabs.com/docs/v20.2/spatial-glossary Spatial data index docs: https://www.cockroachlabs.com/docs/v20.2/spatial-indexes Spatial Data Demo: https://youtu.be/rByg_aMMn8c