Supabase
Supabase
  • 336
  • 2 003 231
Self-host Maps with Protomaps and Supabase Storage
Protomaps[0] is an open source map of the world, deployable as a single static file on Supabase Storage[1].
- Read the blogpost: supabase.link/protomaps-storage-blog
- Find the code: supabase.link/protomaps-storage-gh
Presented by Thor Schaeff (@thorwebdev go.thor.bio/x)
[0] protomaps.com/
[1] supabase.com/storage
CHAPTERS:
00:00 Intro to Protomaps
00:46 PMTiles file format
01:10 Protomaps PMTiles MapLibre example
01:24 Protomaps tooling Quickstart
02:01 Use the PMTiles CLI to cut out an area from Open Street Maps
03:32 Create a new Supabase Project
04:03 Create a new public Storage Bucket
04:51 Configure MapLibre GL to work with the Protomaps Protocol
06:20 Configure MapLibre GL to load vector tiles from Supabase Storage
06:54 Demo of HTTP Range Requests on Supabase Storage
08:48 Security consideration for Supabase Storage
09:09 Proxy through Supabase Edge Functions to restrict access
10:35 Access private bucket storage objects
11:07 Deploy the Supabase Edge Function
11:13 Link your local Supabase project
12:18 Create a private storage bucket
12:48 Load map through Edge Function on the client
💻 Videos to watch next:
▶ czcams.com/video/MWfB0t5u3V0/video.htmlsi=brFBE0SgaX1aEsjW
▶ czcams.com/video/bBu_V8CfWgM/video.htmlsi=SAhGQ043pR4brhHi
▶ czcams.com/video/EwFjETYge9I/video.htmlsi=4vP35_ICJqwdoYCl
👇 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: czcams.com/channels/NTVzV1InxHV-YR0fSajqPQ.html
📱 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 #maps #protomaps #MapLibre
zhlédnutí: 224

Video

How to query with formulas in a scalable way using generated columns
zhlédnutí 1,6KPřed 15 hodinami
Generated columns allow us to calculate a column based on other columns to create a new column for a table. They also allow us to index based on the column, which allows us to scale any query involving the column. Often, queries involving complex formulas do not scale, but generated columns allow us to do so by allowing us to index the column. This can be used for financial analysis, sorting by...
When you SHOULD and SHOULDN'T use Multi-Column Indexes
zhlédnutí 1,5KPřed dnem
Indexing can greatly improve the performance of database queries over a large dataset. Postgres supports Indexing multiple columns, which can be more performant and space efficient, than multiple single-column Indexes. In this video, Jon Meyers demonstrates how to create a Multi-column Index and discusses some of the design considerations and tradeoffs that need to be made. Managing Indexes in ...
Getting started with PostGIS
zhlédnutí 2,6KPřed dnem
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 En...
Debug Edge Functions with Chrome DevTools
zhlédnutí 1KPřed dnem
Since v1.171.0 the Supabase CLI supports debugging Edge Functions via the v8 inspector protocol, allowing for debugging via Chrome DevTools and other Chromium-based browsers. - Read the docs: supabase.link/ef-debugging-tools-docs Presented by Thor Schaeff (@thorwebdev go.thor.bio/x) CHAPTERS: 00:00 Intro to debugging Edge Functions 00:44 New inspect flag in Supabase CLI 01:35 Upgrade the Supaba...
The FASTEST possible way to query data
zhlédnutí 3,9KPřed 14 dny
Covering Indexes are able to satisfy an entire query without performing a lookup on the original source table. In this video, Jon Meyers demonstrates how to include additional columns in an Index, greatly improving the performance of Postgres queries. 🐘 Learn Postgres (Playlist): czcams.com/play/PL5S4mPUpp4Ote6F9ScnXevuOyCnvzahRV.html&feature=shared Postgres is incredibly efficient at filtering...
Generate Images with JavaScript
zhlédnutí 2,3KPřed 14 dny
Amazon Bedrock is a fully managed service that offers a choice of high-performing foundation models. In this video we'll look at how we can get started with Amazon Bedrock and Supabase Vector in Python using the Amazon Titan multimodal model and the vecs Python client. - Find the code: supabase.link/edgy-bedrock-code - Get started with Amazon Bedrock: supabase.link/aws-bedrock Presented by Thor...
Behind the Code of Midday AI
zhlédnutí 3,2KPřed 21 dnem
We're looking behind the scenes of Midday AI[0], an all-in-one tool for freelancers, contractors, consultants, and solo entrepreneurs to manage their finances, track projects, store files, and send invoices. Learn how they were able to build one of the best open source Next.js real-world apps[1] with just one engineer and one designer thanks to services like @Supabase , @triggerdotdev , @resend...
Make your queries 43,240x faster
zhlédnutí 22KPřed 21 dnem
Indexes can greatly improve the performance of a Postgres database, especially as the size of the tables grow. In this video, Jon Meyers demonstrates how to create an index for a particular column, and use explain analyze to measure the optimization. Managing Indexes in Postgres: supabase.com/docs/guides/database/postgres/indexes By default, Postgres creates a B-Tree index, which makes filterin...
Faster queries with index on JSONB columns in Postgres
zhlédnutí 2,2KPřed 21 dnem
The JSONB column in Postgres allows you to store JSON objects while being indexable for fast queries. In this video, Tyler Shukert walks you through adding indexes to a JSONB column so you can run different types of queries efficiently. Learn more about JSON and JSONB columns: supabase.com/docs/guides/database/json Indexes are an essential part of managing databases as they grow. While both JSO...
The Right Way to do Auth with the Next.js App Router - UPDATED
zhlédnutí 10KPřed měsícem
Authentication is essential for modern app development! In this video, Jon Meyers configures Supabase Auth to use cookies, and implements OAuth using GitHub in an Email Client, written with the Next.js App Router. supabase.com/docs/guides/auth/social-login/auth-github The Next.js App Router blurs the lines between Client and Server, therefore, Supabase Auth needs to be configured to use cookies...
Use this to lock down the schema if you have JSON or JSONB columns
zhlédnutí 3,5KPřed měsícem
pg_jsonschema lets you validate schema for your JSON and JSONB columns. In this video, Tyler Shukert walks you through how to restrict the schema of your JSON and JSONB columns to ensure the integrity of the database is kept. Learn more ways to lock down your schema: json-schema.org/learn/getting-started-step-by-step JSON and JSONB columns allow you to be flexible with what type of data you wan...
10 new things you need to try
zhlédnutí 6KPřed měsícem
During GA week, Supabase announced an overwhelming number of new features. In this video, Jon Meyers takes us through his top 10, and why you need to give them a try! 🚀 Top 10 Launches from Supabase GA Week (blog): supabase.com/blog/ga-week-summary 00:00 10 new things you need to try 00:05 Supabase is now GA 00:30 Jon's hair! 00:48 Bootstrap CLI 01:05 Branching is now in Public Beta 01:57 Splin...
Llama 3 with Vercel AI
zhlédnutí 4,2KPřed měsícem
Use Llama 3 with Ollama to stream chat completions from Supabase Edge Functions using the Vercel AI SDK in Next.js. * Blogpost: supabase.link/ai-blog-yt * Docs: supabase.link/ef-ai-llm * Find the code: git.new/vercel-ai-llama3 * Request access: supabase.link/ai-llm-early-access Presented by Thor Schaeff (@thorwebdev go.thor.bio/x) CHAPTERS: 00:00 Intro 00:32 Large Language Models 00:50 Vercel A...
How to store and query JSON data in Postgres
zhlédnutí 5KPřed měsícem
How to store and query JSON data in Postgres
Monitor Database Queries in Next.js Apps with Sentry
zhlédnutí 2,4KPřed měsícem
Monitor Database Queries in Next.js Apps with Sentry
File-based Postgres Analytics with DuckDB and AWS S3
zhlédnutí 3,2KPřed měsícem
File-based Postgres Analytics with DuckDB and AWS S3
8 things you should NEVER do in a Database!
zhlédnutí 9KPřed měsícem
8 things you should NEVER do in a Database!
A new way to use Supabase Storage
zhlédnutí 8KPřed 2 měsíci
A new way to use Supabase Storage
Improve UX with Anonymous Sign-Ins
zhlédnutí 5KPřed 2 měsíci
Improve UX with Anonymous Sign-Ins
Why you should use Edge Functions for AI
zhlédnutí 4,8KPřed 2 měsíci
Why you should use Edge Functions for AI
Supabase is now GA
zhlédnutí 70KPřed 2 měsíci
Supabase is now GA
Self-hosting Supabase on Ubuntu with Digital Ocean
zhlédnutí 10KPřed 2 měsíci
Self-hosting Supabase on Ubuntu with Digital Ocean
🚨 Big Announcement! 🚨
zhlédnutí 6KPřed 2 měsíci
🚨 Big Announcement! 🚨
The Right Way to do Auth with the Next.js App Router!
zhlédnutí 14KPřed 2 měsíci
The Right Way to do Auth with the Next.js App Router!
Building a Donut Slack App Clone
zhlédnutí 1,9KPřed 2 měsíci
Building a Donut Slack App Clone
3 reasons you should use Postgres Functions and Transactions
zhlédnutí 6KPřed 2 měsíci
3 reasons you should use Postgres Functions and Transactions
Add image support to Flutter web application with Supabase Storage | Flutter Figma Clone #4
zhlédnutí 1,8KPřed 2 měsíci
Add image support to Flutter web application with Supabase Storage | Flutter Figma Clone #4
AI Image Search with Amazon Bedrock and Supabase Vector in Python
zhlédnutí 841Před 2 měsíci
AI Image Search with Amazon Bedrock and Supabase Vector in Python
Simplify complex SQL queries with Views in Postgres
zhlédnutí 6KPřed 2 měsíci
Simplify complex SQL queries with Views in Postgres

Komentáře

  • @rembautimes8808
    @rembautimes8808 Před 13 hodinami

    Nice functionality. Good to see polygons defined on maps like the us state boundary and link that to a query on supabase. I used to be able to demo a dynamic google map query from a dashboard, but probably requires some geolocation encoding on the fly

  • @Supabase
    @Supabase Před 13 hodinami

    Thanks for tuning in! Make sure to check out the blogpost: supabase.link/protomaps-storage-blog and the example code: supabase.link/protomaps-storage-gh !

  • @8HcT
    @8HcT Před 14 hodinami

    Does this works on react native web? is giving me problems there, on cellphone no

  • @antdx316
    @antdx316 Před 19 hodinami

    Can I query the Firebase real-time db through The Supabase wrapper?

  • @rembautimes8808
    @rembautimes8808 Před dnem

    Wow - thanks for sharing. Was looking for this video and as I have used RXDB before I can see how it works. Thanks a lot.

  • @georgeflores3134
    @georgeflores3134 Před dnem

    audio sucks 💀

  • @luizvictoriobaptistaneto1561

    For some reason, stripe CLI was not working, even after pnpm install. Installing it globally solved the problem.

  • @powertipsweb
    @powertipsweb Před dnem

    Awesome, thank you for the quality content and great service you provide.❤

  • @champechilufya1458

    Whats the point of this ? What are you achieving or gaining from doing all this? Genuinely asking

  • @champechilufya1458

    Is this new or has it always been there? I think computed columns might have always been a postgres thing, but this allows me to generate unique compound ids, which i can use in conflict upsert type queries. Glad i clicked

    • @dshukertjr
      @dshukertjr Před dnem

      It's relatively new as it was only introduced in Posgres 12, which was released in 2019.

  • @Yusuf-ok5rk
    @Yusuf-ok5rk Před dnem

    hey these new videos of yours are pretty good. keep up the good work. Oh also imo you should add your name + any other person that worked in the video in description.

    • @dshukertjr
      @dshukertjr Před dnem

      Great suggestion! Let me add it in!

  • @shmuel-k
    @shmuel-k Před dnem

    Geberated columns are only able to access data from the current row. So you can't use them for rollup fields or to reference another table. If you need data from another table, you're back to triggers, functions, and views

  • @ubitubee
    @ubitubee Před dnem

    is there a difference, performance-wise, between this method and making functions with triggers?

    • @dshukertjr
      @dshukertjr Před dnem

      Performance-wise probably not. At least nothing significant.

  • @ubitubee
    @ubitubee Před dnem

    do one on different type of indexes and approximate string / natural language search

    • @dshukertjr
      @dshukertjr Před dnem

      Awesome suggestion! Will definitely cover the topic in the future!

  • @brotherly9058
    @brotherly9058 Před 2 dny

    Thanks very much for this!!!!❤❤

  • @dshukertjr
    @dshukertjr Před 2 dny

    We are working on series of Postgres videos on this channel right now! What other Postgres concepts would you like us to cover? Let us know in the comments blow 👇

  • @user-jm5qu3gd4l
    @user-jm5qu3gd4l Před 2 dny

    It seems I haven't found a tutorial for Sign in with Apple using Supabase and Flutter. By the way, how can I link multiple OAuth logins to the same account? I mean binding both Apple and Google to the same account. Of course, it should also work for Web and Android

    • @user-jm5qu3gd4l
      @user-jm5qu3gd4l Před 2 dny

      I apologize first, I didn't see that you also wrote 'Apple sign-in video will also come out soonish.' Sorry.

  • @thibaultbarolat-massole7190

    Great. Does it work with jsonb column?

    • @dshukertjr
      @dshukertjr Před 2 dny

      Yup, that is another awesome use case. You could extract certain values from jsonb columns as a generated column, or you could construct jsonb columns using other columns.

  • @luisandrade1291
    @luisandrade1291 Před 2 dny

    I wish you had shown the execution time of the before and after.

    • @dshukertjr
      @dshukertjr Před 2 dny

      I only had 1000 rows in this particular example, but yes, I should have prepared enough sample data so that I could demonstrate the execution time difference. Trust me though, querying millions of rows with this formula in the query will take a very long time without using a generated column!

  • @akshykhade
    @akshykhade Před 2 dny

    i wasted so much time with triggers and functions for small tasks like this

  • @jaguarconsultoriadigital8147

    Thanks very much.

  • @fawazjoseph878
    @fawazjoseph878 Před 2 dny

    Awesome feature 👏🏿🙌🏿 Can you create a generated column using the supabase ui column editor

    • @dshukertjr
      @dshukertjr Před 2 dny

      It's not quite yet supported, but hopefully in the future!

  • @Omar_Al_Seddik
    @Omar_Al_Seddik Před 2 dny

    Can you please cover storage with Next.js?

  • @AlexMilman_googleplus

    Great video! Thank you. How can I add the product features from stripe to Supabade? What are the required changes to the template?

  • @zeeeeeman
    @zeeeeeman Před 2 dny

    Noob question: why a public.users table? Why not use auth.users?

    • @Justin-oo2xt
      @Justin-oo2xt Před 2 dny

      You can’t query auth.users using the Javascript client

  • @onedayapp3534
    @onedayapp3534 Před 3 dny

    I cant see the AI chat on policies

  • @pedroaquino3042
    @pedroaquino3042 Před 3 dny

    Thank you!! Really helpfull!

  • @mrbjjackson
    @mrbjjackson Před 3 dny

    Have you any tips for having types in our code when processing jsonb data?

  • @advancedprogramming62

    I hope you will publish a video with the name: "How to deploy supabase functions with nodejs"

  • @greendsnow
    @greendsnow Před 4 dny

    ridiculous... i deleted my account after seeing this video. will never touch supabase again. what year are you living in? this is raw PG code... was there no time to build an abstraction over it? why do I need to learn you way of doing things while you're going to change it every 2 years... my brain is not your junkyard!

  • @niccolofontana1049
    @niccolofontana1049 Před 4 dny

    Nice video! Thank you 😊 I am wondering why you don’t enable this feature by default, like Auth0 does, but we have to actually write a bunch of stuff in our project following a documentation page

  • @dshukertjr
    @dshukertjr Před 5 dny

    How can we get the nice hoodie you are wearing? 😂

  • @Trilliant-JP
    @Trilliant-JP Před 5 dny

    Wait, an INDEX can speed up ORDER BY? Learned something new today.

  • @eleah2665
    @eleah2665 Před 5 dny

    Let's whack an index on that! Thanks Jon.

  • @dear_up
    @dear_up Před 5 dny

    you wrapped everything with client component and now whole webside is client side rendered pages, but i need some ssr pages

  • @user-oo2wb8tf7i
    @user-oo2wb8tf7i Před 5 dny

    I have a question. Regardless of whether it is a self-host or a cloud, I want to do a global service with a supabase. The problem is that the service is launched in the United States, but it's too slow because it's accessed from various countries. It would be great if supabase could support multi-regions such as read replication and clustering

    • @nicomiebach
      @nicomiebach Před 5 dny

      Supabase does support multi regions via read replicas.

  • @mithuna5009
    @mithuna5009 Před 5 dny

    On notification click app getting crashes, works fine in expo go but in development client it crashed without any error or I see no logs can you help

  • @saminamanat
    @saminamanat Před 5 dny

    ctrl shift i just blew my mind