Supabase + Bubble connection with API connector

Resolved it.
There was no RLS policy defined.
Even for public view, you have to define policies.

1 Like

Thanks so much for posting your experience, really good info.

What is your view on the speed of Supabase in returning queries? I am considering using it for the analytics in my Bubble app as Bubble’s on DB is starting to get too slow with lots of records.

2 Likes

Hey @siddharth

How is this going? Any issues?

Xano people have found some issues with speed returning data in Bubble and something about proxies, etc.

1 Like

Absolutely no issues from supabase instead I feel like it’s response time has improved a little but I can’t measure that milli seconds time but seriously it is becoming better day by day…

1 Like

My pleasure

Yes seriously this happened to me earlier that is why I shifted.
I can say that the performance and speed of queries are very impressive

1 Like

Thanks @siddharth

Are you planning to make some tutorial to help us the starters :slight_smile: ?

Also, what do you think about Supabase vs Xano?

Thanks a lot man.

2 Likes

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.

1 Like

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.

1 Like

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.

1 Like

Yes indeed :+1:
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.

1 Like

Did you apply policy?

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 :slight_smile:.

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

No
Because I handle Google auth stuff with bubble.

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.

1 Like

Hey @siddharth

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

Thanks a lot.

1 Like

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

2 Likes

There’s no need of proxy😉

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.

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.