Hi guys, is it possible to call third party API within supabase or postgres? Eg. I want to create user in Stripe, when a new user is created in Supabase. When calling the create API within Stripe, i want to store the stripe user ID in my Supabase DB. Is it possible to do it with supabase?

Yep! I do it all the time with the PostgreSQL extension HTTP. I like to use JavaScript to write my functions, so I have a library for this: https://github.com/burggraf/supascript

Interesting! Seems like it will fix the "problem" without needing to build an external API for this.

Definitely. We use Stripe internally at Supabase so it should work very well for you.

But what is best practice? Using it directly on db layer or creating new api?

Best practice probably depends on your use case and what you're comfortable with. Supabase is pretty flexible so you could do it a few different ways. You could write your own server-based layer to talk to Stripe, or you could write PostgreSQL functions to do it. And you could write those PostgreSQL functions in SQL, PLPGSQL, JavaScript (PLV8), or other languages PostgreSQL supports. You could write it as functions that are called by the client through

rpc()

, or by functions that are called by PostgreSQL trigger functions (such as, when a new user is created, a Stripe account is created, then the new Stripe Customer ID is added to a Users table, etc.

Very interesting thread!I had considered using pipedream.com to create a Stripe customer from supabase but a postgres function seems like the way to go. @User I enjoyed your github repos for send email + SMS, I'll try and wrap my head around how to create a similar function but for creating a stripe customer.

Very interested to see this!