Sunday, March 3, 2024
No menu items!
HomeCloud ComputingHow to Connect your Go Application to Cloud SQL

How to Connect your Go Application to Cloud SQL

The Cloud SQL Go connector is the easiest way to securely connect your Go application to your Cloud SQL database. If you are writing a Go application, we recommend using the Cloud SQL Go connector.

When to use the Cloud SQL Go connector

Cloud SQL has two types of connectors:

Language-specific connectors – Available for Java, Python, and Go.

Cloud SQL Auth proxy – A good choice when a language-specific connector is not available.

These connectors come with significant advantages over a traditional database connection. We laid out a few of the benefits of using a connector in our previous blog post: Understanding Cloud SQL connectors. With code-level control, the Cloud SQL Go connector is the most convenient way to securely connect your Go Application to your database.

Try it out

The GitHub ReadMe includes usage documentation for PostgreSQL, MySQL, and SQL Server for integrating the connector into your application. To show just how easy it can be, we’ve released a Codelab for How to connect a Go application on Cloud Run to a Cloud SQL for PostgreSQL database.

In a single `main.go` file, this application:

accepts HTTP requests

securely connects to the Cloud SQL for PostgreSQL database using a service account with automatic IAM database authentication

stores the time of the HTTP request in the database

returns the times of the last five visits

With the Go Connector, you get all the best-practices of connecting securely out of the box.

AlloyDB Connector

One last exciting note. Go is the first language to have a language-specific connector for AlloyDB. The AlloyDB Go connector is built on the Cloud SQL connector, so with minimal changes to swap out the library, the code you write for Cloud SQL will work if you ever decide to use AlloyDB.

Related Article

Understanding Cloud SQL connectors

Securely connect your application to PostgreSQL, MySQL, and SQL Server databases running on Cloud SQL using Cloud SQL connectors.

Read Article

Cloud BlogRead More

RELATED ARTICLES

LEAVE A REPLY

Please enter your comment!
Please enter your name here

Most Popular

Recent Comments