this is exactly what I was looking for, understanding the db side of subscriptions, with rules and such. Thank you so much for the video.
@JonMeyers
5 ай бұрын
Awesome! Glad you enjoyed it! 🙌
@ewwitsantonio
5 ай бұрын
Supa helpful tutorials! Thanks for creating these videos. :)
@JonMeyers
5 ай бұрын
Thanks for watching! Glad you’re enjoying them 🙌
@selambengp
5 ай бұрын
What a lovely reminder of the db password 😂❤
@JonMeyers
5 ай бұрын
I wish projects had analytics on number of times the database password had been reset! Much faster than a password manager! 😂
@nicken86
3 ай бұрын
So thankful for this playlist! Any chance you could walk through how to handle if a user downgrades from a higher level subscription to a lower one, and how to handle that with the rules setup?
@sourceblocks62
8 күн бұрын
Awesome! Question: is it recommended to check subscriptions and usage limits in Supabase (at database level) with functions and triggers or in my codebase? For example, in my Nextjs app I'm fetching the user's subscription status before doing any action like adding notes. I'm also deducting credits from a user after they add a note, using the Supabase client from my route in my app. Should all this be handled in Supabase functions at database level and in my routes just have basic fetching, updating without subscription or usage logic? Or is it ok as I'm doing?
@jrdnrc
5 ай бұрын
jon the legend did it again
@JonMeyers
5 ай бұрын
Thanks Jordi! Glad you enjoyed it! 🙌
@Oreoezi
5 ай бұрын
Why can't we use the RLS insert policy instead of a trigger to make sure a user cannot insert a row if they exceed the limit?
@JonMeyers
5 ай бұрын
You can enforce this with RLS but it is better practice to separate your security and business logic. Security-wise you want the user to be authenticated to insert, and only insert a row that belongs to them. Enforcing the limits of each subscription tier is business logic. Security -> RLS Business Logic -> Trigger But you can implement it however you prefer in your app 👍
@R0cky0
5 ай бұрын
Great tutorial Jon. A couple of questions: 1. did you generate the random text IDs with prefix for product/sub/price_* through JS? does Supabase have such function other than generating uuid? 2. Would do a quick walkthrough on how to apply the expiration date rule and possibly with a notification before the plan expires? Many Thanks! 🙏
@JonMeyers
5 ай бұрын
Thanks for watching! Glad you enjoyed it! 🙌 1. These were created in the Stripe dashboard, triggering webhook events that are sent to Supabase 👍 2. That’s a great idea! Will add it to the list!
@StefanRows
5 ай бұрын
For those where pnpm supabase:pull doesn't work: npx supabase db pull Also, npx supabase migration up works. No idea why the pnpm commands fail for me (latest version on everything)
@JonMeyers
5 ай бұрын
Good call! I think I tinkered with the package.json scripts to record the video - need to push those up to the template 👍
@brandonhargitay7098
Ай бұрын
thanks man!
@codewrangler
5 ай бұрын
Yet another great video Jon! The way you walked us through the function logic was fantastic. Question: does the raise exception message get passed back to the supabase query on the client side or just in the PG backend?
@JonMeyers
5 ай бұрын
Thanks! Glad you enjoyed it! Yep, the exception gets returned as an ‘error’ in supabase-js 👍
@damianocellai1783
5 ай бұрын
Hello, what happen if i go to a plan that let me create a 5 notes and later i downgrade? They let me downgrade? How handle this with Stripe, Next and Supabase? Thanks a lot for your content
@JonMeyers
5 ай бұрын
Currently, this would allow you to keep the notes, you just couldn’t add any new notes until you upgrade again. But you handle this anyway you prefer. Could add an “active” column to each of the notes and automatically deactivate the ones above 5 if they downgrade their subscriptions
@rtorcato
5 ай бұрын
if the user goes pro adds more notes then the limit then cancels their pro plan they still get to keep more notes allowed.
@JonMeyers
5 ай бұрын
Yep, correct! Currently, they would keep the extra notes, but you can handle this in your app any way you want 👍 One option would be add a column for “is_active” to the notes table. You could automatically set the notes above 5 to inactive when the user downgrades their subscription. Or set up a grace period of 7 days for them to delete the additional notes or upgrade their subscription
@Tanner-cz4bd
5 ай бұрын
Can we get a full next js tutorial building a high quality CRUD app
@JonMeyers
5 ай бұрын
Will add it to the list 👍
@Tanner-cz4bd
5 ай бұрын
@@JonMeyers thanks
@yarapolana
5 ай бұрын
Can we get another remix auth tutorial with @supabase/ssr?
Пікірлер: 28