How to Connect Google Cloud SQL using Bubble SQL Connector

Need help
1

Hi there.

I am trying to create an app using bubble.
There is one question about Bubble SQL Connector Plugin.

How do I change set up example as following??

mysql://username:password@my-db-instance.endpoint.us-east-1.rds.amazonaws.com:PORT/db_name

I would like to connect Google Cloud SQL database using Bubble SQL Connector Plugin.

Here is my idea.

  • mysql → SQL Type such as mysql, postgres, windows sql
  • username →GCP Database username
    password → GCP Database password
    @my-db-instance.endpoint.us-east-1.rds.amazonaws.com → ???
    PORT→up to sql type
    db_name→ db name

Please give me advice if you have any solutions.
Thank you!!

2

I did it!

Here is my answer.

postgres://<username>:<password>@<host>:5432/<dbname>

<username>：Database username <password>：Database Password <host>：GCP Cloud SQL Public IP address <dbname>：Database name

I checked Heroku Docs.

3

@okamoto hello ! thanks for your post :wink:
I have a question regarding this post, how do you set up the IP adress ? do you open it to all trafic ? I asume you work with a dedicated plan since personal plan does not have a fixed IP
thanks !

4

Hello.

Thank you for checking my post.
You mean all traffic can access to the IP address when anyone knows the IP address, right??
If so, yes. I have to use a dedicated plan, so I skipped using Bubble SQL Connector because it is worried about security.
Thank you.

5

@okamoto thanks for your reply.
dedicated plan will be too expensive for me - i ll have to find another solution :wink: but thanks

6

@Alter345

No problem.

i ll have to find another solution

Sounds good. Could you share me with your solution if possible???

7

@okamoto I heard that we could set up something like this : AWS Lambdas with a static outgoing IP | by Financial Engines TechBlog | Financial Engines TechBlog | Medium