Getting started with PostGIS

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: supabase.link/postgis-docs
Presented by Thor Schaeff (@thorwebdev 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:
▶ • How to use Supabase Ge...
▶ • How to perform geograp...
▶ • Calculate distance and...
👇 Learn more about Supabase 👇
🕸 Website: supabase.com/
🏁 Get started: app.supabase.com/
📄 Docs: supabase.com/docs
🔔 Subscribe for more tutorials and feature updates from Supabase: / @supabase
📱 Connect with Us:
🐙 Github: www.github.com/supabase
💬 Discord: www.discord.supabase.com/
🐦 Twitter: / supabase
▶ Instagram (follow for memes): / 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

[@Supabase]

Thanks for tuning in! You can find the docs here 👉 supabase.link/postgis-docs

[@dshukertjr]

PostGIS is my favorite Postgres extension! It's so much fun playing around with maps on Postgres!

[@Thiago-uf8oo]

this video WAS INCRIBLE!!

[@gobajoseph5064]

En tant que catographe j'attendais ce moment avec impatience. J'ai hate de voir les autres épisodes sur comment faire du temps réel avec postGis. Si par exemple des églises loue le même local comment les representer dans postGis et sur une carte . Comment peut-on ajouter de l'IA générative dans postGis. J'ai vraiment hate merciii🎉🎉🎉

[@Supabase]

Merci pour vos commentaires! Maybe this approach would work for you? github.com/bdon/supabase-vector-tile

[@zenitsu4139]

Will you guys add a feature for indexedDb like electricsql. It would be really helpful if supabase has an inbuilt indexeddb

[@thorwebdev]

Have you looked at LegendState before? There is a new Supabase plugin for it. Wonder if that might solve your use case?

[@Supabase]

Have you looked at LegendState before? They just released a Supabase Plugin which might be useful for your use case: supabase.link/legend-state

[@DinoRossYT]

Wow legend-state seems pretty solid and easy to implement, definitely a big yes for heavy data products

[@spzagams2089]

First❤

[@spzagams2089]

We need More support for flutter

[@dshukertjr]

Is there any particular content that you would like us to work on regarding Flutter?