Use an ORM

Go ORM support for YugabyteDB

GORM is the ORM library for Golang.

CRUD operations with GORM

Learn how to establish a connection to a YugabyteDB database and begin basic CRUD operations using the steps on the Build an application page under the Quick start section.

The following sections break down the quick start example to demonstrate how to perform common tasks required for Go application development using GORM.

Step 1: Import the ORM package

Import the GORM packages by adding the following import statement in your application's main.go code.

import (
  "github.com/jinzhu/gorm"
  _ "github.com/jinzhu/gorm/dialects/postgres"
)

Step 2: Set up the database connection

Go applications can connect to the YugabyteDB database using the gorm.Open() function.

conn := fmt.Sprintf("host= %s port = %d user = %s password = %s dbname = %s sslmode=disable", host, port, user, password, dbname)
var err error
db, err = gorm.Open("postgres", conn)
defer db.Close()
if err != nil {
  panic(err)
}
Parameter Description Default
host Hostname of the YugabyteDB instance localhost
port Listen port for YSQL 5433
user User connecting to the database yugabyte
password Password for connecting to the database yugabyte
dbname Database name yugabyte

Step 3: Create a table

Define a struct which maps to the table schema and use AutoMigrate() to create the table.

type Employee struct {
  Id       int64  `gorm:"primary_key"`
  Name     string `gorm:"size:255"`
  Age      int64
  Language string `gorm:"size:255"`
}
 ...

// Create table
db.Debug().AutoMigrate(&Employee{})

Read more on designing Database schemas and tables.

Step 4: Read and write data

To write data to YugabyteDB, use the db.Create() function.

// Insert value
db.Create(&Employee{Id: 1, Name: "John", Age: 35, Language: "Golang-GORM"})
db.Create(&Employee{Id: 2, Name: "Smith", Age: 24, Language: "Golang-GORM"})

To query data from YugabyteDB tables, use the db.Find() function.

// Display input data
var employees []Employee
db.Find(&employees)
for _, employee := range employees {
  fmt.Printf("Employee ID:%d\nName:%s\nAge:%d\nLanguage:%s\n", employee.Id, employee.Name, employee.Age, employee.Language)
  fmt.Printf("--------------------------------------------------------------\n")
}

Next steps