Database Connector Connection string dynamically

marco10 · 2024-12-03T12:44:23.687Z

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!

tylerboodman · 2024-12-03T23:54:50.437Z

Can you use the API connector to interface with SQL ? Then you can leave the whole URL dynamic

bubble.trouble · 2024-12-03T23:58:35.760Z

I need a dynamic Connection string APIs

In our pro plugin there is a place in the plugin settings to specify the dev connection string and the live connection string respectively. SQL Database Connector Pro Plugin | Bubble

marco10 · 2024-12-04T12:00:42.220Z

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.