Supabase Wrappers: A Framework for Building Postgres Foreign Data Wrappers

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

yes, that's correct. we've built a read-only version for Stripe (which is API-based), and we aim to have the read/write implementation done soon.

You will be able to do something like this:

    insert into stripe_products (name)
    values ('Pizza'), ('Pasta');

This will insert a value into Stripe via the API. Then you can query your stripe products like this:

    select *
    from stripe_products
    limit 10;

[ Parent | on HN ]

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 ]

Re:Supabase Wrappers: A Framework for Building Postgres Fore... by omnibrain on Thursday December 15, 2022 @01:46PM (#34003819)

So I could implement one myself for arbitrary REST APIs?

I can't wait for somebody offering a generator, where you plug in your API, it pulls and parses the JSON, then you can select the fields you want and it generates the wrapper. (Alternatively, for put/post you could supply your own JSON).

Practically like some low/no code tools like Appsmith/Budibase and the likes already do today.

Sadly I lack the necessary skills and more important the time to dive into that.

[ Parent | on HN ]

Re:Supabase Wrappers: A Framework for Building Postgres Fore... by kiwicopple on Thursday December 15, 2022 @01:56PM (#34003945)

Yes, I guess it would be possible to works with generic REST APIs - ones that all conform to a similar model.

> generator, where you plug in your API, it pulls and parses the JSON, then you can select the fields you want and it generates the wrapper

Probably on this one the wrapper could use an OpenAPI spec

[ Parent | on HN ]