About this guide
This development guide walks you through everything you need to do to build a high-quality Next.js app integrated with Supabase DB and Stripe. Check out the tasks below to get started. To save time, you can also use our boilerplate, which gives you a complete React codebase with all of these tasks done for you. Okay, let's dive in!
Tasks
Setup your Next.js app
Create a Next.js app usingnpx create-next-app
and then run your project locally with thenpm run dev
command.Create Supabase query hooks
Create React hooks that wrap your Supabase queries, such asuseUser
,useItem
, anduseItemsByUser
. These hooks should fetch data and return a query status of "success", "loading", or "error". The React Query library makes it especially easy to setup these hooks and have components re-render when data changes.Create Supabase tables and policies
Create the database tables that your app requires. For a simple SaaS app you could start with tables forusers
,customers
anditems
. Yourcustomers
anditems
tables would generally have auser_id
column that referencesusers.id
. You can create these tables right in your Supabase dashboard, but we recommend writing acreate table
SQL snippet for each table, allowing you to easily recreate them in the future. Lastly, you'll want to enable Row Level Security for your tables and secure read/write access with policies.Setup a trigger to create user in database on signup
When a user signs up with Supabase Auth you'll want to automatically insert their data to theusers
table so that you can easily query on it. This can be accomplished with a trigger. Setup a trigger that inserts a new row into theusers
table when a user signs up. You'll also want to create a trigger that updates that data when a user's auth email changes. This ensures that your database is always in sync with user data in Supabase Auth.Build a data-driven UI
Create a data-driven UI using your component library of choice that reads/writes data to Supabase. The specifics will depend on the type of app you're building, but we generally recommend having auseItemsByOwner
hook that fetches "items" in Supabase that are owned by the current user. You can then create a component for displaying that data in a simple list or table if more columns are needed. Finally, you'll want create a flow for creating and updating items utilizing modal and form components.Create a Integrate with Stripe CheckoutNext.js API route at
/pages/api/stripe-checkout.js
that receives aplanId
value, creates a new Stripe Checkout session for the given plan usingstripe.checkout.sessions.create()
, and then returns thesession
object. Next you'll create a/purchase/[planId]
page that initiates the checkout flow. This page should automatically make a request to/api/stripe-checkout
to get a new Checkout session and and then redirect to Checkout by callingstripe.redirectToCheckout(session.id)
. Finally, you'll design your plan selection UI using your component library of choice and link each plan to the/purchase/[planId]
page you've setup above.Create a Integrate with Stripe Customer PortalNext.js API route at
/pages/api/stripe-portal.js
that creates a new Stripe Customer Portal session usingstripe.billingPortal.sessions.create()
and then returns thesession
object. Next you'll create a/settings/billing
page that initiates the Customer Portal flow. This page should automatically make a request to/api/stripe-portal
to get a new session and then redirect to the Customer Portal using thesession.url
value. Next you'll create a settings UI using your component library of choice and link to the/settings/billing
page you setup above. Now your users can easily manage billing info and change payment methods.In order to handle Stripe payment events you'll need to setup a webhook server endpoint. Create a Create a Stripe webhookNext.js API route at
/pages/api/stripe-webhook.js
that uses thestripe
library to parse data from the request body, validate the event usingstripe.webhooks.constructEvent()
, and then call a handler function for each of the following events:checkout.session.completed
,invoice.payment_succeeded
,invoice.payment_failed
,customer.subscription.updated
, andcustomer.subscription.deleted
. Your event handlers should update the user in the database so that your database contains their current plan and subscription status. When running your app locally, Stripe won't be able to ping your webhook endpoint, so you'll want to make sure to use the Stripe CLI to listen to events and route them to your local/api/stripe-webhook
endpoint.
Get the code
You can get the code for this guide with our Next.js, Supabase DB, and Stripe Boilerplate. You'll get a complete Next.js codebase with Supabase DB and Stripe integration, all the tasks listed above done for you, and a responsive multi-page template. It should save you about two weeks of development time.
127 downloads today