Hi- a database design question. I’m going to gradually move my database from bubble to supabase. For the time being, I’m thinking of moving some heavy data operations like key API calls and writes to supabase.
Question is how would I connect bubble with supabase? Do I need to have two independent oauth? Or do I just pass bubble’s unique user id as a field to supabase and set like RLS with bubble’s unique user id as an authorization criteria?
I do not have answers, I just have questions.
The reason I ask these questions is that I have a way of using a Hybrid Data Structuring approach in Bubble that for many use cases of an external DB, makes it so that you wouldn’t need to go through all the complicated steps of keeping an external DB in sync with Bubble app and user authentication issues etc.
API calls or using a plugin that has those same API calls already setup.
I believe there is an Oauth requirement that I’ve seen on the forum people requesting help for so seems a bit tricky but not impossible to achieve.
Outside of WU optimization, I would like to implement vector and semantic search functionality, which i can’t quite do via Bubble database.
No, I don’t think you could. So you’d be best served to setup Supabase. I think the biggest struggle is the user authentication, but once you get that handled, the rest of the time you are using Supabase it is just like any other API call which means you can use the supabase values via dynamic expressions just like you would any other data type in Bubble, so super simple to continue building in Bubble any other features you need while still using Supabase.
Check out some of the plugins available for supabase, as they may have already built out the necessary user authentication stuff, but I do not have experience to recommend any specific plugin.
