Supabase + Bubble connection with API connector

siddharth · 2022-10-27T14:47:14.483Z

Initially I thought and planned, but due to shortage of time I was unable to do that, so I thought of writing in a tutorial way will be much easier and quicker for me that is why I posted this on the forum.

siddharth · 2022-10-27T15:01:55.686Z

ryanck:

Also, what do you think about Supabase vs Xano

As I have used Xano I can say that it is very very simple yet so-so powerful for no coders you can say for the people who is just looking for a specific no code database. So when are database is focused and it is created in a way keeping no code in mind you won’t get that complexity and openness of a database you can say a scalable database. Xano is also scalable but the upper limit is somewhat questionable also we need to consider here the pricing.
On the other hand we have supabase which is a fire base open source alternative. So first of all a file base alternative needs to be as powerful as fire base and I can say that supa base is of course that much powerful and also being open source we have lot and lot of advantages which we all know. So as it is incredibly scalable and corporate scale database with terms of people always keeping it in a proper touch through GitHub you can always trust it more. Secondly it comes to pricing and seriously there is a lot of difference between the pricing of super base and xano which can be easily determined by visiting their pricing pages.
Comparatively there are other features which needs to be in a database say tomorrow if you want to leave bubble and make that app in react or any JavaScript framework or Android of course it can be easily integrated through their SDK or other native connectors.
And of course lastly I will say depends on once personal choice see I wanted something powerful firebase and after a lot of research I found at it can’t be easily connected with bubble and after week off work I finally give up and look for an alternative so this was my case but yet it can be different for different people and different use cases. At the same time I also considered Xano but after looking at my database size which you can also see on the first post it was too complex for xano and costly. Any other API rate limiting was also very irritating.

ryanck · 2022-10-28T08:52:49.725Z

Hey @siddharth

Thanks for the thorough reply. So you think Supabase is better than Xano, right?

How do you accomplish the issue of: for example, have a page with invoice line items so every time a line item is created, the it goes to Supabase and then Bubble must get the Supabase line item real time?

Thanks a lot man.

siddharth · 2022-10-28T16:20:20.485Z

ryanck:

you think Supabase is better than Xano, right?

Yes indeed
The invoice thing I didn’t understand clearly I mean why should a line go to supabase and then back to bubble, can u please elaborate a little @ryanck ? but the thing that you said of real time then yes it is real time. Because if you have a condition like that every time a data changes bubble automatically queries supabase to see if the result have changed or not and it’s also reflected real time.

bkimambo94 · 2022-10-28T17:35:22.522Z

Did you apply policy?

ryanck · 2022-10-29T07:44:12.987Z

Hey @siddharth

Well imagine you have an invoice page where you have a table with line items since how Bubble works you need to insert a record to each line item so that would be creating records in database. How could this be real time? I haven´t seen any external API going as fast as the Bubble database real time performance wise.

Do you have any example?

Thanks a lot .

akyanirudh3 · 2022-11-16T09:54:15.708Z

Did you try to use google auth provided by supabase to login users from your bubble front end ? Would be helpful , thanks

siddharth · 2022-11-17T18:39:03.120Z

akyanirudh3:

Did you try to use google auth provided by supabase to login users from your bubble front end ?

No
Because I handle Google auth stuff with bubble.

victorgirondi · 2022-11-29T00:26:45.851Z

Thanks so much for this. I connected Supabase to Bubble but I’m not sure how to get realtime working properly within Bubble. Do you know how to achieve it? When I delete or create a new element I need to refresh the page to see the change.

ryanck · 2022-11-30T12:37:17.612Z

Hey @siddharth

How do you avoid going through Bubble´s server via proxy?

Thanks a lot.

siddharth · 2022-11-30T12:57:06.766Z

Unfortunately the realtime feature of supabase is not possible with API as of now, it uses listeners which needs supabase-js to work.

siddharth · 2022-11-30T12:57:31.935Z

There’s no need of proxy😉

gerbertdelangen · 2022-11-30T13:20:55.401Z

Maybe you can use Supabase’s webhooks together with a data type (f.i. refresh) in which entries are created when a record is created/updated/deleted in Supabase. Additionally add a bit of logic which subscribes users to entries in this refresh data type when they are on a certain page / have a certain repeating group visible using conditions.

ryanck · 2022-11-30T13:59:43.481Z

Hello @siddharth

I’m not saying there is need but that all the connections that go through the API connector are proxied then are slower.

So the question is how you got rid of that limitation?

Thanks a lot.

dominok56 · 2022-12-01T13:38:45.023Z

@siddharth Can I build a plot with the data from the Supabase API? I made a lot of tries, but I don’t really understand how can I use a data from the API in Data Source field while building a plot

siddharth · 2022-12-01T13:57:14.667Z

@dominok56 Can u please define “plot”

siddharth · 2022-12-01T14:00:26.695Z

Actually I didn’t have any ideas about proxy here
But I can say that the response is really fast

ryanck · 2022-12-01T14:02:26.584Z

Hey @siddharth

It´s fast but not as Bubble so when it comes to speed and compliance, getting out of the Bubble servers is necessary.

If you take a look at it let me know

Thanks a lot.

dominok56 · 2022-12-01T14:04:47.255Z

@siddharth I meant a chart

siddharth · 2022-12-01T15:08:14.079Z

In the API connector there will be a drop-down option
to use this API as action or use as data you should be marking it as a data in order to get it in proper data position.