Hello,
In an application, I would like to dynamically set the SQL Database Connector plugin connection string for different IPs (the connection is for Postgres) at runtime, according to some parameter in the URL (or any other means).
If this is not possible, at least choose the query connection at runtime. In this case, I would create several connections (for different IPs) and choose which one I would like to query in the query.
I find it incredible that there is no way to do this in Bubble!
Can you use the API connector to interface with SQL ? Then you can leave the whole URL dynamic
I tried, but my Postgres database is on a dedicated server, not one of those commercial cloud ones, like Supabase… So I have no idea how it would be to connect via the API Connector.
1 Like