Skip to main content
Brave Programmer Logo

BraveProgrammer

BraveProgrammer

HomeProjectsBlogsCoursesLessonsAbout

Site footer

BraveProgrammer

Free coding courses, practical tutorials, and real projects from BraveProgrammer. Learn web development with React, Next.js, and TypeScript.

Navigation

  • Home
  • Projects
  • Blogs
  • Courses

Resources

  • About
  • Lessons
  • Teach on BraveProgrammer

© 2026 BraveProgrammer. All rights reserved.

Working with Databases – `d | Go Programming Bootcamp lesson | BraveProgrammer
  1. Courses
  2. /
  3. Go Programming Bootcamp

Lesson 24 of 60

·Go

Working 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)
    }
}
func
main
()
"user=alice password=secret dbname=mydb sslmode=disable"
"postgres"
if
nil
defer
// Ping to verify connection
if
nil
// Query
"SELECT id, name FROM users WHERE active=$1"
true
defer
for
var
int
var
string

Using sqlx for convenience

$ go get github.com/jmoiron/sqlx
import "github.com/jmoiron/sqlx"

var db *sqlx.DB
// db.Get(&dest, "SELECT …", args…)

Info

Always close rows (defer rows.Close()) and handle errors from Scan.
Make it stickPractice what you've learned1 quiz · 3 practical tests · Optional activities from Go Programming BootcampBrowse activities
Previous lessonBuilding a CLI with CobraContinue to lesson 25Testing HTTP HandlersBack to Go Programming Bootcamp curriculum