gcp-cloud-run-contacts

An example app using GCP Cloud Run with Cloud SQL.

Project ID

• Set the GitHub actions secret GCP_PROJECT_ID

Database preparations

https://cloud.google.com/sql/docs/postgres/connect-run

• Create a Cloud SQL postgres instance.
• Connect to the instance (gcloud sql connect) and create the contacts table:

create table if not exists contacts (
    id serial primary key,
    name varchar(100),
    email varchar(100)
);

• Obtain the INSTANCE_CONNECTION_NAME (gcloud sql instances describe).
• Set the GitHub actions secret GCP_SQL_CONNECTION_NAME.
• Determine the postgres Data Source Name (DSN): user=postgres password=<password> database=postgres host=/cloudsql/<INSTANCE_CONNECTION_NAME>
• Set the GitHub actions secret GCP_SQL_DSN.

Service account

• Create a service account and obtain a JSON key (https://github.com/google-github-actions/deploy-cloudrun/)
• Set the GitHub actions secret GCP_CREDENTIALS.