Supabase + Bubble connection with API connector

[siddharth]

@jaimeisaac

do you have to keep a some basic tables on bubble

No we need to have some inputs ready and then click of a button it will initiate a post call so inputs value will be directly sent to the supabase
Therefore no need to have tables where data will be temporary stored and then sent.

So you have a form or single input and after the users fills the input it will click on a button and with a click of the button a post API request will be initiated to the superbase and done. After then you can reset the inputs or display a pop up or a message to user

@jaimeisaac

Do you manage users on bubble or do you rely on supabase for users too

I sometime use the later while some times the former, it totally depends on the type of application and what the infrastructure will be.

[siddharth]

@jaimeisaac

posible to notify bubble when a table in supabase has changed

No that function it not possible with bubble because that can only be implemented through SDK or JavaScript which will constantly hear from the supabase table and gets into action when something is changed.

For a go around, if you want update of your database every x min

Supabase + Bubble connection with API connector

Well I have a solution, Call a GET call use it as action Make a group where data should be displayed Add a Refresh button or icon or make it do it after every x minutes or second and in the workflow call the same API Hope it helps

[jaimeisaac]

Hello , how do you save response from supabase api?

[jaimeisaac]

Thank you,

So what i need to do is to connect Jotform webhook to supabase, send data and read every X hours supabase from bubble right? Can supabase accept webhooks data?

[jaimeisaac]

Hello sir,

After selecting capture response in api call, how do i access the data in those responses? i tried to set up a custom state but i cant do it because response comes as objects. Thank you

[nickdev]

You can save the response by selecting the response type as text or data type as you may wish to save as type

[nickdev]

Yes it do accept

[shu.teopengco]

[New Plugin] Supabase.js - With Auth, Data and Storage

[New Update 1.2.0] “Data” now has Realtime functionality which listens to Database Changes, and refreshes the query. This uses the “Postgres Changes” realtime server which is done via Websockets. You can enable or disable Realtime with the checkbox, and it takes the initial filter into account, and also RLS. (Please don’t forget to check that your table has Realtime enabled, and also RLS is ok too). Here’s realtime in action, with two browser opened. Added some more Auth providers for Oauth2 W…

Anyone used this?

[keith]

Yes. It has 7 installs.

[jaimeisaac]

I saved the fields im interestd in as text.

Created a custom state with data type as the API get

And set up a workflow to catch data from REsult of calling that API

API works fine but i cant read the 201 response.

Also i tried to setup de custom text as text and same.

Can you pont me out to my error?

Thank you

[shu.teopengco]

For those migrated to supabase. How did you managed the primary keys or unique ids?

Does bubble create a unique if that can be used with ids in supabase? If yes, what will be the correct format? String? Int8? Uuid?

[jaimeisaac]

I beleive supabase automatically creates primary id on each added row. Bubble just send API Post and Supabase adds the id to it.

[nickdev]

Yes you are correct whenever you create a new row in supeabase a primary number is assigned. It is always started from one and increase as per rows.
Even and the time of creation of new table a primary key is there by default you can change the name of that primary key from ID to anything

[jeansemcodar]

And images, was I able to make a call for sending and image search?

[nickdev]

For storing and retrieving images you need to use Supabase Buckets which is also very easy and API ready

[jeansemcodar]

Hi nickdev, that’s the problem, the database API’s are very well documented. But that of Storage, nor the path I could not find.

It always says it doesn’t exist.

https://.supbase.io/???

tks

[nickdev]

https://supabase.github.io/storage-api/
There you go

[elciolima]

Obrigado, isso me ajudou muito!

[vismayee]

Hi @siddharth Great to hear, thanks for sharing the info about Supabase. Does it mean that repeating group is updated in realtime?
Currently I use self hosted PostGres on bubble, the issue is repeating group does not show realtime updates. However flutterflow with Firebase DB gives a reatime update on list view (Similar to Bubble repeating group).
If it means same with bubble then it would be a game changer for Bubble

[tylerboodman]

No realtime with API connector, there is realtime with Supabase.js Plugin | Bubble however