Yes here is the setup i have on my database:
and here is what I try to retrieve:
but it gives me blank or 0
Best regards
Hi @valere.taravella
Thank you for the details. The count is retrieved by adding a specific header to the request and I saw an issue in this particular case where some browser extensions block certain headers.
Would you mind trying with another browser?
Hi @Nass,
I am having an issue with RPC. It appears that Bubble does not wait for it to finish before moving to the next step. So, I create a custom event that returns the object of the RPC. That custom event is then called when I click a group element, and the result of the custom event is needed in the next step. Thus the need to wait for the RPC to finish. However, when I debug, the custom event is returning an empty object from the RPC. What is more weird is that when I inspect the RPC object in Bubble, it shows the expected object nicely. In summary, the custom event returns empty, but bedugging shows the expected result stored in the RPC object, and I think what’s happening is that he RPC is taking a little long to complete and Bubble moves on to the next steps and returns the empty object. But after a few more seconds, the RPC competes and gets the data normally. But I could not figure out how to make Bubble wait for the RPC to be complete. Do you have any suggestions to fix this? Thanks!
BTW: After testing a little more, the issue only occurs the first time I click the group. From second click and beyond it works perfectly even if I click a different row in the repeating group which means, the parameter of the RPC changes.
Hey @flaviovs
Could you please try using the “RPC has changed” event? The RPC results should always be available after this event.
Just to let you know, in the next plugin version:
- This event is renamed to “Call success”
- You’ll be able to specify the return type of the RPC, so there’s no need to format the results as a JSON object anymore
I tried it before. But I just found the issue: The issue was because the RPC element was inside a hidden group. Once I moved the RPC out of the hidden group, it worked as expected. Sorry I did not notice this simple detail earlier.
1 Like
Hi,
I’m excited to let you know that plugin v2 is just about ready to go live!
Before you upgrade to this new version, please be aware that these two components have been removed:
Data container
The data container component has been removed due to maintenance challenges and occasional synchronization issues with Bubble.
I recommend using Bubble’s native features, such as reusables and exposing data through custom states on reusables. If this solution doesn’t fit your needs, feel free to drop me a DM.
Using reusables: https://supabase-editor.bubbleapps.io/version-test/structuring_app
Admin component
The admin component has been fully replaced by server-side actions, offering much more flexibility.
If you need any assistance with the upgrade, please don’t hesitate to contact me.
I’ll share the full changelog soon, but here are a few new features:
Database
- New actions for managing realtime subscriptions giving you more control over the database realtime channels.
- Added “Referenced table” field for sorting through embedded table fields.
- New field “Convert to null” for handling empty payload values.
Auth
- A new event “Supabase is loaded” has been added. This event triggers only once on page load when the authentication states are fully available (Logged-in, email, etc).
- Multi-factor authentication (MFA) actions for enrollment and verification.
Custom auth
- Allows you to grant your Bubble users access to your data in Supabase, so you can keep your users on Bubble while securing access to your database tables. You can use the “Generate JWT” action to create tokens for authentication.
Uploader
- New field to set custom metadata for uploaded files.
- Image compression support.
Storage
- Create signed URLs, retrieve public URLs, and download files in bulk.
- Option to create a Zip archive while downloading files.
RPC
- The RPC component now supports multiple types, allowing you to return different types of results from your RPC functions.
Since this is a major release there might be a few issues.
If you run into any, please let me know and I’ll make sure to fix them as soon as I can.
Best!
2 Likes
Wondering if anyone can help. I need to create a recursive workflow that iterates through a list of things, adding each one to ‘add to bulk’ ready for them to be uploaded to a supabase database.
The issue I’m having is - how do I add the step of ‘add to bulk’ for the recursion given backend workflows do not allow you to add element actions?
Hi @kimbern
One way to implement this is to use the Simple looper plugin.
You can then:
- Add the Simple looper element to your page
- Run the “Start looping” action in a workflow
- Then start a workflow triggered by this event:
On this workflow, you can:
- Call the “Add bulk data” action
- Call the “Run next iteration” action
- Call the “Finish looping” action
Finally, you can call the insert action using the bulk data as payload
The complete workflow:
Best!
1 Like
Hi, @Nass
In our project on bubble we want to build a database on supabase and, of course, choose your plugin for quick setup and further management.
The only thing is that our supabase database will be deployed on its own server.
Can you tell me if the plugin will work correctly in this case? Will there be any limitations in using the plugin?
Hi @klyuchonline,
While I don’t have specific tests with self-hosted Supabase instance this should work properly.
If you run into any issues, just send me a DM, and we’ll figure it out together.
1 Like
Brilliant. Thanks so much Nass. Sorted!
1 Like
Hi @Nass, we are trying to use your Bubble supabase page elements to filter on variables that are in a joined table. It looks like the filter does not work on this joined variables.
Ex: select : id, table(id, name)
→ We can filter on id, but on table.name (e.g. using a .eq(‘table.name’, ‘xxx’))
Thanks in advance
The syntax you’re using looks good.
For example, if you have two tables: Projects and Clients where each project is associated with a client via the client_id foreign key.
Fetch projects where client.name is “Client 1”
PS: please note that Supabase will also return projects where the client is null.
Fetch projects where client.name is “Client 1” excluding those where client_id is null
Let me know if you could solves your issue.
Best!
Hi @Nass , I would like to ask you if it is possible to add a “reset / clear” action of fetched data in a database supabase? It would be VERY useful for SPAs where Reusable Elements are used as pages in the application.
For example, when a reusable element disappears, using a true condition event I would like to remove all previously retrieved data from the supabase database element. Really, it would be very important to have this action 
Thanks!
Hi @lorenzodelia125
Okay, I’ll add a new “Reset” action for the database component. Please note that it will reset all states (Objects, Object, Bulk data, Status code, etc…).
I’ll let you know as soon as it’s released.
Best!
Hi,
The plugin v2 is finally available for update.
Before you upgrade to this new version, please be aware of these changes:
Data container
The data container component has been removed due to maintenance challenges and occasional synchronization issues with Bubble.
I recommend using Bubble’s native features, such as reusables and exposing data through custom states on reusables. If this solution doesn’t fit your needs, feel free to drop me a DM.
Admin component
The admin component has been fully replaced by server-side actions, offering much more flexibility.
Deprecated
All actions and states marked as deprecated on v1 have been removed:
- Database: removed the “RPC” action. You can use the RPC component instead.
- Uploader: removed states: File path, File URL, File name, and File extension. You can use the “Data” state instead.
- Storage: removed states: Buckets, Files, and Uploads. You can use the “Files” state instead.
PS: the selected “Count” value for fetch might reset after the upgrade. So if you’re using it when fetching data, make sure to check if the value is still there.
I’ll publish a migration guide in the next few days, but here are some tips:
Supabase is loaded
If you need to call actions on page load using auth states (User ID, User email, Is logged in?, etc.), you can use the new “Supabase is loaded” event triggered by the auth component instead of Bubble’s “Page is loaded” event. This event is triggered only once when the user session details have been retrieved.
Unsubscribe from realtime
To save resources, when you no longer need real-time changes on your DB, you can now use the new “Unsubscribe from realtime” action to unsubscribe from all the real-time channels subscribed by a database component (Main table and joined tables).
If you need to resubscribe to changes, you can simply call the “Subscribe to realtime” action.
If you find any issues or need assistance with the upgrade, please don’t hesitate to send me a DM.
Best!
It’s perfect! Thank you!
Hey @lorenzodelia125
The “Reset” action for the database component is available (v2.0.2).
PS: If you’re still on plugin v1, please make sure to carefully read the breaking changes with v2 in my previous messages before upgrading. 
Best!
1 Like