Is it possible to connect to GCP CloudSQL Postgres DB using Bubble SQL Connector?

kontakt8 · 2024-10-23T08:30:16.199Z

Hi!
Is it possible to connect to GCP CloudSQL Postgres DB using Bubble SQL Connector?
I’m pretty sure my connection string is correct but still I cannot connet. Is it even possible to do so?
I"m using postgres://username:encodedpassword@publicIP:5432/DBname

senecadatabase · 2024-10-23T12:16:16.641Z

So a couple of quick things…

first, you shouldn’t use the public IP.

Second, you should use UNIX sockets.

You should use a Cloud SQL Proxy.

Your string should be like this:

postgresql://username:password@/dbname?
host=/cloudsql/project:region:instance

just replace with your info.

kontakt8 · 2024-10-23T12:44:51.954Z

So, should I change something on the Cloud SQL side?
I got an error:

Your connection string does not fit the standard string. It should look like mysql://username:password@my-db-instance.endpoint.us-east-1.rds.amazonaws.com:PORT/db_name.

senecadatabase · 2024-10-23T12:49:02.914Z

Does your Bubble project have the correct IAM permissions?

It looks like Bubble has their own way of doing things.

You might want to try a Cloud SQL proxy?

senecadatabase · 2024-10-23T13:02:55.718Z

The main problem I run into with Bubble is I can build an app from the ground up using code…

and I know how things should work.

However, when I try what I know should work in Bubble there can be problems because Bubble has it’s own way of doing things.

Myself, I end up having to change several things…but I only discover I need to change them by having access to everything on the site.

Virtually anything can be done with Bubble…sometimes it’s hard to diagnose it though by suggesting something and not being able to try it hands on.

I find coding much easier than the Bubble way…but, I still think Bubble is a good platform for those that don’t want to take years to understand all the platforms most large apps use.

My suggestion is to just try different tweaks and see which one works with Bubble.