Connecting a backend with Stripe

[jenstroeger]

Hello, Suppose a PostgREST backend that needs to connect to a payment service (e.g. Stripe) and in a way proxy between the user ⇔ PostgREST backend ⇔ Stripe.

I came across

• the pgsql-http extension which allows to send & receive HTTP which I guess I’d use to handle the Stripe API directlty; or
• Supabase’s foreign data wrapper (link) to a Stripe account.
• Alternatively, I’d trigger an async job (e.g. in Python) from the backend which then talks to the Stripe API.

And then there are Stripe’s Events which I’d poll or I’d provide a URL to which Stripe sends these events (webhooks).

What experiences and recommendations does the community have?

Thank you!