balderdashy/sails

App Engine Deployment with Cloud SQL

Open

#7,004 opened on Jun 3, 2020

View on GitHub
 (7 comments) (0 reactions) (0 assignees)JavaScript (1,953 forks)batch import
help wantedormpostgresqltry this out please

Repository metrics

Stars
 (22,778 stars)
PR merge metrics
 (No merged PRs in 30d)

Description

Node version: 12.16.0 Sails version (sails): 1.2.4 ORM hook version (sails-hook-orm): 2.1.1 Sockets hook version (sails-hook-sockets): 2.0.0 Grunt hook version (sails-hook-grunt): 4.0.0 DB adapter & version (e.g. sails-mysql@5.55.5): sails-postgresql@1.0.2

I was able to deploy with GCP app engine in flex environment. But I am anot able to access my cloudsql postgres resource. As app engine supports different notation [/cloudsql/INSTANCE_CONNECTION_NAME] to represent resources in app engine. https://cloud.google.com/sql/docs/mysql/connect-app-engine-flexible. If I am using that notation, in application logs. it defaults to localhost for db

Contributor guide

Research direction
Investigate how Sails.js resolves the database host setting when using the Cloud SQL socket path `/cloudsql/INSTANCE CONNECTION NAME`. Look at the database adapter's connection logic and any environment variable mapping.
Tech stack
javascriptnodejssqlpostgresql
Domain
backendclouddatabase
Issue type
Bug
DifficultyEstimated implementation difficulty for a new contributor, from 1 for very small changes to 5 for expert-level work.
2
Estimated timeA rough time range for an experienced contributor to investigate, implement, test, and prepare a pull request.
1-3 hours
Activity statusHow available the issue appears right now: fresh, active, stale, blocked, or waiting on maintainer input.
Active
ClarityHow clearly the issue explains the expected change, acceptance criteria, and next step.
Mostly clear
Prerequisites
Node.jsGitCloud SQL knowledge
Newbie friendlinessA 1-100 score estimating how approachable this issue is for first-time contributors.
65