Supabase Linter automatically detects Security and Performance optimizations, and provides helpful suggestions for how to resolve them. In this video, Jon Meyers goes through 8 common issues that can be surfaced with Splinter!
🙋 Supabase Security Advisor & Performance Advisor (blog): https://supabase.com/blog/security-performance-advisor
00:00 Automatically Identify Security and Performance Optimizations in Postgres
03:08 Unindexed Foreign Keys
05:09 Unused Index
07:25 Duplicate Index
08:20 Exposing auth.users Table
15:46 RLS Disabled on Public Table
16:40 RLS Enabled with No Policy
18:58 Invoking auth.uid() Function for Every Row
20:10 Multiple Permissive Policies
22:35 Go deeper with Postgres Theory
💻 Videos to watch next:
▶ Supabase is now GA: https://www.youtube.com/watch?v=bRtdk8D4X8w
▶ Learn Postgres (playlist): https://youtube.com/playlist?list=PL5S4mPUpp4Ote6F9ScnXevuOyCnvzahRV&feature=shared
▶ A new way to use Supabase Storage: https://www.youtube.com/watch?v=WvvGhcNeSPk
👇 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://www.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 #RealtimeApps #DeveloperTools