Getting started with PostGIS скачать в хорошем качестве

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: 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: ▶    • How to use Supabase GeoQueries with PostGI...   ▶    • How to perform geographical queries using ...   ▶    • Calculate distance and average speed with ...   👇 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:    / @supabase   📱 Connect with Us: 🐙 Github: https://www.github.com/supabase 💬 Discord: https://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