PostGIS extends the capabilities of the PostgreSQL relational database by adding support for storing, indexing, and querying geospatial data. Learn how easy it is to get started with PostGIS and Supabase in this tutorial.
- Read the docs: https://supabase.link/postgis-docs
Presented by Thor Schaeff (@thorwebdev https://go.thor.bio/x)
CHAPTERS:
00:00 Intro to PostGIS
00:26 Create a new Supabase Project
01:03 Enable PostGIS on Supabase
01:34 Enable PostGIS on a separate Schema
02:24 Enable Postgres extensions in the Supabase Dashboard
03:05 Create a table with a geography column
03:17 Store lat long locations in PostGIS
04:14 Create a spatial index
04:49 Insert latitude and longitude data into Supabase
05:48 Spatial proximity Query
05:55 Create a remote procedure call to query from the client-side
08:50 Recap & Outro
💻 Videos to watch next:
▶ https://youtu.be/-_Wpr7rwU8I?si=BI2gYq0pHSDRMLC_
▶ https://youtu.be/agFsGDJxjwA?si=q-OU4SCvSaoxoAdf
▶ https://youtu.be/cRn0MXLkN-U?si=us848HGsq5D25mLK
👇 Learn more about Supabase 👇
🕸 Website: https://supabase.com/
🏁 Get started: https://app.supabase.com/
📄 Docs: https://supabase.com/docs
🔔 Subscribe for more tutorials and feature updates from Supabase: https://www.youtube.com/channel/UCNTVzV1InxHV-YR0fSajqPQ?sub_confirmation=1
📱 Connect with Us:
🐙 Github: https://www.github.com/supabase
💬 Discord: https://discord.supabase.com/
🐦 Twitter: https://www.twitter.com/supabase/
▶ Instagram (follow for memes): https://www.instagram.com/supabasecom/
ABOUT SUPABASE:
Supabase is the open source Firebase alternative. Supabase provides a full Postgres database for every project with pgvector, backups, realtime, and more. Add and manage email and password, passwordless, OAuth, and mobile logins to your project through a suite of identity providers and APIs.
Build in a weekend, scale to millions.
#Supabase #AppDevelopment #DeveloperTools #postgres #postgis #thorwebdev