Connect with Go

SingleStore is wire-compliant with MySQL, which means you can connect to your SingleStore workspace with Go similar to a MySQL database.

Prerequisites

  • A SingleStore workspace

  • Go

  • The mysql module for Go:

    go get github.com/go-sql-driver/mysql

Connection Details

To connect your Go application to your SingleStore workspace, you'll need the following information:

  • Host: the endpoint or IP Address of your SingleStore Helios workspace.

  • Port: default is 3306

  • User: admin

  • Password

  • Database

Here's an example of a Go connection for a SingleStore Helios workspace:

func main() {
HOSTNAME := "svc-12345678-1234-1234-1234-2d4b84322fd8-ddl.aws-region-1.svc.singlestore.com"
PORT := "3306"
USERNAME := "admin"
PASSWORD := "<your admin password>"
DATABASE := "acme"
connection := USERNAME + ":" + PASSWORD + "@tcp(" + HOSTNAME + ":" + PORT + ")/" + DATABASE + "?parseTime=true"
db, err := sql.Open("mysql", connection)
}

More Information

For a complete example, including samples of CRUD operations, refer to this GitHub repository.

For information on using stored procedures with Go, see GitHub.

Last modified: April 5, 2023

Was this article helpful?