Loading...
Setting-up workflows around the Products
Setting-up workflows around the Products
Let’s now work on the products table. This table will be filled-in with the various products (or plans) that we will create inside Stripe. Each product will also hold the rules regarding the access to each available feature (what we call feature entitlement)
Payments
Learning Highlights
- 0:18
Learn how to structure a products table in Supabase that mirrors Stripe's subscription plans, including pricing and feature entitlements for each tier.
- 3:23
Understanding enumerated types in databases ensures data consistency by restricting column values to predefined options like 'monthly' or 'yearly' for billing cycles.
- 5:03
The key to managing subscription features lies in storing boolean flags for capabilities like export, email sending, and rollback alongside credit limits in your database schema.
- 7:23
Stripe stores prices in cents (e.g., $9 = 900 cents), so maintaining this format in your database ensures consistency when integrating with Stripe's API.
💡
Interactive diagram used in the video
Setting-up workflows around the Accounts
Create an accounts table to map Stripe customers and store their plan-based feature entitlements.
Prompt Used in Video
Ready to start a new course?
Continue your learning journey with these carefully curated courses
Course
Setting-up a database with Supabase, and building our first CRUD API endpoints
Learn how to connect your application to a Supabase database, then validate the setup by creating your first API endpoints to perform basic CRUD operations (Create, Read, Update, Delete).
6 lessons
0 min
Jules BoiteuxFounder @Vibe Coding Academy
Course
Webhooks Mastery for Product Builders
Many third-party integrations rely on webhooks. Stripe is one of the most important examples, which makes it essential to understand how to implement webhooks correctly in your app and build reliable business logic on top of them.
5 lessons
0 min
Jules BoiteuxFounder @Vibe Coding Academy
