Getting started with PostGIS

preview_player
Показать описание
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.

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:

👇 Learn more about Supabase 👇

📱 Connect with Us:

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
Рекомендации по теме
Комментарии
Автор

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

dshukertjr
Автор

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🎉🎉🎉

gobajoseph
Автор

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

zenitsu
Автор

It's incredibly powerful. Unleashing the beast! I see Google maps competitors coming

shsunmoon
Автор

ERROR: 42883: function st_point(numeric, numeric) does not exist

SimonKlimekNetwork