nextjs-subscription-payments icon indicating copy to clipboard operation
nextjs-subscription-payments copied to clipboard
verified publisher icon vercel

Switch to Foreign Data Wrapper (FDW)

Open throwaway34241 opened this issue 2 years ago • 3 comments

I just read about Supabase's new Foreign Data Wrappers here, and in particular, there's one for Stripe: https://github.com/supabase/wrappers/tree/main/wrappers/src/fdw/stripe_fdw

As far as I understand, it means that we could swtich the following tables to foreign in schema.sql: customers, products, prices, subscriptions etc, since they can be queried via the FDW. And we can delete all webhooks!

Is it worth migrating this repo to use the Stripe FDW?

throwaway34241 avatar Dec 21 '22 10:12 throwaway34241

Yes, once ready we'll take a look at that.

thorwebdev avatar Jan 16 '23 03:01 thorwebdev

any news on this?

mworks-proj avatar Feb 28 '23 19:02 mworks-proj

I'm really curious about this too.

There is a post on the superbase subreddit that seems to argue for webhooks: https://www.reddit.com/r/Supabase/comments/17k1jk1/stripe_webhooks_v_supabasewrappers/

Here is a post in the supabase discord that also argues for webhook: https://discord.com/channels/839993398554656828/1167917737796968538

So is it really advantageous to switch to Stripe FDWs? Is network speed really that big an issue?

nleroy917 avatar Aug 13 '24 17:08 nleroy917