Hi everyone!
I’m seeking some guidance on a tricky issue we’re facing with SQL connectors in our app. We’re dealing with complex queries that involve multi-faceted filtering, and we’re running into some challenges.
The Challenge:
We cannot define an environment variable directly on the plugin and as we can’t dynamically change the Data Type on the page this results in a cumbersome process where we have to create RG twice every time we use SQL, complicating maintenance and impacting page load performance due to the increased number of elements.
Our Setup:
- We’re using Bubble on a dedicated server.
- We have read-only access to the SQL server.
Current Workaround:
The only solution I’ve found so far is to return a list of IDs from my SQL query, then use the Toolbox plugin to convert these into my App Thing. This then becomes my RG datasource. However, this approach isn’t ideal because:
- It doesn’t allow for custom responses (it return all Thing columns).
- It can’t return columns from JOIN operations, forcing us to redo this within Bubble.
What We’re Looking For:
- A more efficient way to handle dynamic Data Types without the need for redundant RG creation.
- Solutions or plugins that might simplify our process.
- Any tips or best practices for managing complex SQL queries and filtering in Bubble.
Thanks in advance for any suggestions or advice you can offer!
