Skip to content

Instantly share code, notes, and snippets.

Last active Jun 23, 2021
What would you like to do?
Go Example: Google CloudSQL with CloudSQL Proxy and GORM
package main
import (
_ "database/sql"
_ ""
// You can read more in this post:
func main() {
// Using cloudsql-proxy will help you avoid white listing IPs and handling SSL.
// In this case, it will also run inside your Go program and will not require
// an additional process or container.
// Connection String details:
// * user - the user created inside the DB. You can see more details on how to create it without password here:
// * project-id - your project id
// * zone - your general zone (us-central1/us-west1/etc)
// * db-name - the name of the database instance as it appears in the console
var dbConnectionString = "user@cloudsql(project-id:zone:instance-name)/db-name?charset=utf8&parseTime=True&loc=UTC"
var db *gorm.DB
var err error
if db, err = gorm.Open("mysql", dbConnectionString); err != nil {
Copy link

austincollinpena commented Oct 7, 2020

It's now in the docs, towards the bottom:

Copy link

erans commented Oct 7, 2020

Thanks. It's nice to know. Thanks for sending the link!

Copy link

tlboright commented Apr 13, 2021

This is awesome. Thanks!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment