Usage-based restrictions for SaaS subscription tiers

Usage-based restrictions are used to differentiate the value provided by each subscription tier. In this video, Jon Meyers uses a combination of PostgreSQL Functions, Triggers and RLS policies to ensure a user is only able to do the number of things their subscription tier allows!

Full playlist:    • Fastest way to build a SaaS with Next...  

Additionally, he uses the Supabase CLI to create a shadow database, diff schemas and automatically generate a Postgres migration file, using a git-like "push and pull" workflow to keep multiple instances of Supabase in sync. This allows new features to be collaboratively developed, and safely rolled out to production, without breaking your SaaS product! 🚀

00:00 Usage-based restrictions for subscription tiers in SaaS product
04:21 Generate Postgres migration file with Supabase CLI
09:17 Creating the table we want usage-based restrictions for
12:12 Writing database access rules with Row Level Security (RLS) policies
17:13 PostgreSQL Functions and Triggers to implement business rules
31:35 Push local schema changes to prod using Postgres migrations

💻 Videos to watch next:
▶ Fastest way to build a SaaS in 2024 - Next.js, Supabase and Stripe:    • Fastest way to build a SaaS in 2024 -...  
▶ Fastest way to get started with Next.js and Supabase in 2024:    • FASTEST way to get started with Next....  
▶ Implement Authorization using Row Level Security with Supabase:    • Implement Authorization using Row Lev...  

👇 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://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 #RealtimeApps #DeveloperTools