Hi Zeroqode,
I’m currently building a dashboard in Bubble using your Supabase Pro Kit plugin, and I had a question regarding caching behavior for RPC calls.
With the Bubble SQL Connector plugin, there was built-in behavior where a query would only be executed once for a given set of parameters, unless those parameters changed — effectively acting as a session-based cache to prevent redundant calls.
I’m trying to reproduce this logic for Supabase RPC calls using your plugin. Specifically, I’d like to:
-
Avoid re-fetching if the same RPC (with the same arguments in body) has already been called during the session
-
Still allow new calls if parameters change
My questions:
-
Is caching available for RPC calls, or is it limited to standard database queries?
-
If RPC caching is not supported yet, is there a recommended approach to implement this behavior within your plugin? At the moment, I’m using a custom cache system with JSON arrays.
-
Are there any plans to extend caching to RPC calls in future updates?
Example use case: On my dashboard, I have a dropdown filter. When the user changes the value, a new RPC call is made to fetch updated data. If the user switches back to a previously selected value, I’d like to avoid re-calling the same RPC unless the parameters are different.
Thanks again for your support and all the great work you’re doing on the plugin!