cloudsql - ActiveState ActiveGo 1.8

Package cloudsql

import ""

Overview ▾

Package cloudsql exposes access to Google Cloud SQL databases.

This package does not work in App Engine "flexible environment".

This package is intended for MySQL drivers to make App Engine-specific connections. Applications should use this package through database/sql: Select a pure Go MySQL driver that supports this package, and use sql.Open with protocol "cloudsql" and an address of the Cloud SQL instance.

A Go MySQL driver that has been tested to work well with Cloud SQL is the go-sql-driver:

import "database/sql"
import _ ""

db, err := sql.Open("mysql", "user@cloudsql(project-id:instance-name)/dbname")

Another driver that works well with Cloud SQL is the mymysql driver:

import "database/sql"
import _ ""

db, err := sql.Open("mymysql", "cloudsql:instance-name*dbname/user/password")

Using either of these drivers, you can perform a standard SQL query. This example assumes there is a table named 'users' with columns 'first_name' and 'last_name':

rows, err := db.Query("SELECT first_name, last_name FROM users")
if err != nil {
	log.Errorf(ctx, "db.Query: %v", err)
defer rows.Close()

for rows.Next() {
	var firstName string
	var lastName string
	if err := rows.Scan(&firstName, &lastName); err != nil {
		log.Errorf(ctx, "rows.Scan: %v", err)
	log.Infof(ctx, "First: %v - Last: %v", firstName, lastName)
if err := rows.Err(); err != nil {
	log.Errorf(ctx, "Row error: %v", err)

func Dial

func Dial(instance string) (net.Conn, error)

Dial connects to the named Cloud SQL instance.