Stripe wrapper support
Hi Supabase team,
I’m trying to use the wrappers extension in my project. It installs successfully and shows up in pg_extension, but it never registers itself as a foreign data wrapper.
• select extname from pg_extension; → shows wrappers installed.
• select fdwname from pg_foreign_data_wrapper; → only shows postgres_fdw.
• When I run:
create server if not exists stripe_server
foreign data wrapper wrappers
options (wrapper 'stripe');
I get:
ERROR: 42704: foreign-data wrapper "wrappers" does not exist
So the extension is present, but the FDW isn’t being created.
Could you confirm if the wrappers build on my instance is missing FDW registration, or if something needs to be reinstalled/updated on your side?
Thanks!
5 Replies
Do you have guide you are using?
I see this one:https://supabase.com/partners/integrations/supabase_wrapper_stripe
And it has different code than you show.
I’ll try this and follow back
Doesn’t work for connect accounts it’s what i found
I assume you are saying in general it does not work for a portion of the stripe data...
I don't know anything about the wrapper itself.
This is the repository for issues and any detail of inner workings or requests for features would likely best happen there. https://github.com/supabase/wrappers?tab=readme-ov-file#wrappers
GitHub
GitHub - supabase/wrappers: Postgres Foreign Data Wrapper developme...
Postgres Foreign Data Wrapper development framework in Rust. - supabase/wrappers
The stripe wrapper is excruciatingly difficult to set up, and slightly confusing to use unless you understand the underlying stripe API well.
The hard part is that the "key_id" you need from the vault is different on every installation because it is auto-assigned by the DB. For some reason the developer who built it decided to use the randomly assigned key ID instead of the unique vault item name that you set when inserting values into the vault. Scripting this is thus infinitely hard.
The code Gary shared with you is the right way to set it up.
I'm sure if you wanted you could build out the interface to expose the stripe connect APIs as tables. The code is open source.