Package pgxv4 provides an AlloyDB driver that uses pgx v4 and works with the database/sql package.
Functions
func RegisterDriver
func RegisterDriver(name string, opts ...alloydbconn.Option) (func() error, error)RegisterDriver registers a Postgres driver that uses the alloydbconn.Dialer configured with the provided options. The choice of name is entirely up to the caller and may be used to distinguish between multiple registrations of differently configured Dialers. The driver uses pgx/v4 internally. RegisterDriver returns a cleanup function that should be called one the database connection is no longer needed.
Example
package main
import (
"database/sql"
"log"
"time"
"cloud.google.com/go/alloydbconn/driver/pgxv4"
)
func main() {
// Note that sslmode=disable is required it does not mean that the connection
// is unencrypted. All connections via the proxy are completely encrypted.
pgxv4.RegisterDriver("alloydb")
db, err := sql.Open(
"alloydb",
"host=project:region:instance user=postgres dbname=postgres password=password sslmode=disable",
)
if err != nil {
log.Fatal(err)
}
defer db.Close()
var now time.Time
if err := db.QueryRow("SELECT NOW()").Scan(&now); err != nil {
log.Fatal(err)
}
log.Println(now)
}