Connect with Go

Warning

SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.

Prerequisites

A SingleStore cluster
Go
The mysql module for Go:
Shell
```
go get github.com/go-sql-driver/mysql
```

Connection Details

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

Host: the endpoint or IP Address of your SingleStore cluster.
Port: default is 3306
User: root
Password
Database

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

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.