Supabase is an open source Firebase alternative built on PostgreSQL. It provides a suite of tools to build your application, including authentication, database, and storage.
contacts
table in your Supabase database. Or “Customers” in Stripe become a customers
table in your Supabase database. You can then integrate this data into your application using Supabase’s tools.
This guide explains how to setup a sync between Sequin and a Supabase Postgres database.
sequin
user in your Supabase database. Run the code snippets in the SQL Editor in your Supabase dashboard to create the user:
sequin
user to connect Sequin to your Supabase database.
First, get the connection credentials for your Supabase database. In the Supabase dashboard, go to the settings page and open up your Database settings. In the Connection info section, you’ll find the credentials for your database.
Now, enter the database connection details in Sequin.
sequin
user and password you created in the previous step 👆5432
).postgres
).stripe
or salesforce
)sequin
user you created.sequin
user you created.true
.host
, port
, database
, user
, and password
provided to you on the Connection instructions tab of your Sequin sync.
JOIN
data), you’ll need to grant the sequin
user permission to access these tables. To do so, run the following grants in the Supabase SQL editor:
sequin
user. The above grants are just an example.user_id
as a metadata key in your stripe.customer
table so you can easily join between the two. Then, you can use the user_id
to return the subscription status with a join:
stripe.customer
table with the following query: