Questions tagged [google-cloud-sql]
Google Cloud SQL is a service that allows you to create, configure, and use relational databases that live in Google's cloud. It is a fully-managed service that maintains, manages, and administers your databases, allowing you to focus on your applications and services.
google-cloud-sql
3,856
questions
0
votes
0
answers
21
views
Connecting to Google Cloud SQL from Cloud functions gen2
I am having trouble connecting to cloudSQL from CF gen2. I was using gen1 functions and deploying them with gcloud functions deploy command. The connection is through Unix Socket. Cloud SQL runs on ...
1
vote
1
answer
32
views
I cannot connect to my Cloud SQL instance via my Golang app in Cloud Run: "hostname resolving error: no such host"
Here are the technologies I am using:
Terraform
Golang + pgx/v5/pgxpool
Cloud SQL (PostgreSQL)
Cloud Run
Cloud Build
I have provisioned my PostgeSQL instance like so:
terraform {
...
- 1,046
2
votes
0
answers
41
views
How can I run migrations, using go-migrate, inside cloud run against a postgres cloud sql instance? [duplicate]
I've been stuck this issue for the past few days. Here is my database that connects to the DB instance and attempts to run migrations against it:
func connectToDb() (*pgxpool.Pool, error) {
...
- 1,046
1
vote
0
answers
27
views
Next.js connect to Google Cloud PostgreSQL gives error "Module not found: Can't resolve 'oracledb'", but I am not using Oracle at all
I trying to create an application in Next.js with typescript that will connect to Google Cloud PostgreSQL database. I get an error Module not found: Can't resolve 'oracledb'. The
code is for ...
- 1,090
0
votes
1
answer
65
views
How to connect Sequelize to Google Cloud SQL database when I have deployed my Node.JS backend api?
I have a Node.js + Express backend API, and I use Sequelize ORM to query my database. My database runs on google cloud SQL and I use the MySQL dialect.
So here is my index.js now where I initialize ...
- 7
0
votes
1
answer
22
views
Timestamp comparison and conversion to application server timezone issue with CloudSQL DB
Since cloudsql by default stores timestamp values in UTC format, how can we make the conversion of the timestamp between the application layer and DB.
The application server is MST time zone based and ...
0
votes
1
answer
61
views
Why would Mysql return "error Column cannot be null"?
We recently moved our mysql version to mysql 8 but we are facing a really strange behavior some (valid) queries that would work before like a charm stopped working (sometimes) for no reason and mysql ...
0
votes
0
answers
72
views
Cloud SQL MySQL Connection Refused: SQLSTATE[HY000] [2002] – How to Resolve?
I'm trying to connect my application to a Google Cloud SQL instance running MySQL, but I'm encountering a "Connection refused" error. Below are the details of the error and the steps I’ve ...
- 81
0
votes
0
answers
19
views
How to Trigger Cloud Functions from Firebase Extension Events for Cloud SQL Integration?
I’m using a Firebase extension for resizing images and I have a Cloud Function that should be triggered after the resizing process is completed. The goal is for this function to generate download ...
0
votes
2
answers
43
views
How to connect python with cloud sql mysql
I'm trying to connect my code in Python with a mysql instance that is in Cloud SQL, I created a user for myself and I'm using the public i available in the instance interface as host, but I'm getting ...
0
votes
1
answer
39
views
Unable to pip install google.cloud.sql.connector when building docker image
I am using Python developing a web app in my local machine. I am using the code from Connect using Cloud SQL Language Connectors to connect to my GCP Postgres database and working fine! However, when ...
- 3
0
votes
0
answers
41
views
Datastream using private connectivity
You can help me, please?
I have try to create the reverse proxy to make connection from Datastream VPC to CloudSQL.
The VM is close connection with CloudSQL database, but when i run the "Test ...
0
votes
2
answers
101
views
Trying to find the `recommended dns` data for GCP Cloud SQL instance
I'm working through the documentation for connecting to a private Cloud SQL instance. I created the instance with a private IP (no public access), set up cloud sql proxy on my local, and am able to ...
- 8,314
0
votes
1
answer
108
views
Connect to Cloud SQL from Cloud Run with a NextJS/Prisma setup
Context
I'm developing a NextJS 14 application using google services.
I also use Prisma as my ORM, which works by having a DATABASE_URL (postgresql://postgres:password*^@IPaddress/dbname?schema=public&...
0
votes
0
answers
46
views
Where can I find the 'ivf' access method for creating an index on a vector column?
The GCP docs (https://cloud.google.com/sql/docs/postgres/understand-example-embedding-workflow#create-index) give an example for creating an index on a vector column:
CREATE INDEX complaint_embed_idx ...
- 41