Supabase Wrappers: A Framework for Building Postgres Foreign Data Wrappers

Re:Supabase Wrappers: A Framework for Building Postgres Fore... by thedangler on Thursday December 15, 2022 @11:50AM (#34002264)

Is there documentation on how to interact with a API for the wrapper? The API I'm probably going to try this with needs some crazy logic to parse the responses and does everything through query parameters.

Can't wait until this is ready.

[ Parent | on HN ]

Re:Supabase Wrappers: A Framework for Building Postgres Fore... by kiwicopple on Thursday December 15, 2022 @11:58AM (#34002380)

You'd need to build a specific wrapper for that API. For example, here[0] is the wrapper for Stripe (docs[1])

I think you're looking for something more generic, like pg_net[2]. This would allow you to do your crazy logic by parsing your API response:

    select net.http_get('https://news.ycombinator.com') as request_id;

    select body, status_code from net.http_collect_response(1, async:=false);

[0] Stripe src: https://github.com/supabase/wrappers/tree/main/wrappers/src/...

[1] Stripe docs: https://supabase.github.io/wrappers/stripe/

[2] pg_net: https://supabase.github.io/pg_net/api/

[ Parent | on HN ]