How to Use sqlx for Easier Database Access in Go

Use sqlx.Connect to open a connection and sqlx.Select to scan rows directly into Go structs.

import "github.com/jmoiron/sqlx"

type Person struct {
    FirstName string `db:"first_name"`
    LastName  string `db:"last_name"`
    Email     string
}

func main() {
    db, err := sqlx.Connect("postgres", "user=foo dbname=bar sslmode=disable")
    if err != nil { log.Fatal(err) }

    var people []Person
    err = db.Select(&people, "SELECT * FROM person ORDER BY first_name ASC")
    if err != nil { log.Fatal(err) }

    fmt.Printf("%#v\n", people[0])
}

sqlx is a helper library that makes working with databases in Go easier by letting you map database rows directly to your Go structs. Instead of manually scanning each column into a variable, you define a struct with tags, and sqlx fills it automatically. Think of it as a bridge that automatically translates database data into the Go objects you want to use.