I was trying to use an external database that can easily integrate with my bubble app via API and also need to be much powerful enough to withstand thousands of calls and filtering.
my choice - Firebase but as i saw was not that rest API friendly especially Realtime one also had hard time figuring it…
Next my option was Zano and Backendless but the price was very high, limited API calls and I was having doubt about reliability and future dependency. They were more concerned on no code db thing than actual db itself (just my own thoughts I am not saying its bad)
I also considered baserow but still I was not at peace of mind
I really wanted firebase kind of thing so after a lot of research in the field, I get to know about Supabase which actually was a firebase alternative and opensource.
I search this forum about how can I connect supabase but I got really got 0 answer or clues And so after days of figuring out how to connect with bubble I finally get my answers.
Actually their support was awesome on discord and so i really liked that🙃
Now I have successfully connected my bubble app and it works flawlessly so i why not share this to my Bubble community and now I am here typing
I am currently in Free plan which includes
500MB database & 1GB file storage
50MB file uploads
Unlimited API calls with filtering
Awesome support on discord
Now here’s my tables of orders which have
In this orders table I got 1,106,999 rows
And I have many others tables (clients, leads, internals) and some of them have more than 100k rows each
The total space used were:
Now here’s how we can get the API details for our connector.
Firstly we need to create a project and a table after that opening it
by selecting the appropriate table and the api calls are dynamic as per your tables
by selecting bash we gat all the rest API details and endpoints
in bubble API connector we have to add two shared headers as
- authorization with Bearer#space# api key
Get Api key in Supabase here
To get all therows of table
To get a specific order details using order id
https:// yehstwuktowapuuiwawm.supabase. co/rest/v1/orders?order_id=eq.[value]
also add row, update and delete selected are very simple and its doc can be found on the supabase API page
make sure you use all the name of rows, tables in SMALL CAPS because that will only work as Supabase use Postgres Database
I am not connected to anyways with supabase i found it great and so i M sharing this
So guys hope you liked it and if you have any queries feel free to reply