Lesson 24 of 60
GoWorking with Databases – `database/sql` and Drivers
25 minutes
Course progress40%
Database Access
This lesson explains the main concept clearly with beginner-friendly examples and background so you can learn why the code works.
The database/sql package provides a generic API; you need a driver (e.g., github.com/lib/pq for PostgreSQL).
import (
"database/sql"
_ "github.com/lib/pq"
)
{
dsn :=
db, err := sql.Open(, dsn)
err != { log.Fatal(err) }
db.Close()
err := db.Ping(); err != { log.Fatal(err) }
rows, _ := db.Query(, )
rows.Close()
rows.Next() {
id
name
rows.Scan(&id, &name)
fmt.Println(id, name)
}
}