8 things you should NEVER do in a Database!
Supabase Supabase
25.9K subscribers
6,755 views
0

 Published On Apr 19, 2024

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-pe...

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: Ā Ā Ā ā€¢Ā SupabaseĀ isĀ nowĀ GAĀ Ā 
ā–¶ Learn Postgres (playlist): Ā Ā Ā ā€¢Ā LearnĀ PostgresĀ Ā 
ā–¶ A new way to use Supabase Storage: Ā Ā Ā ā€¢Ā AĀ newĀ wayĀ toĀ useĀ SupabaseĀ StorageĀ Ā 

šŸ‘‡ 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://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 #RealtimeApps #DeveloperTools

show more

Share/Embed