SQLite with Go

Database Web Database

2026-04-17T12:05:42+00:00

Connect to SQLite in Go using the database/sql package and a driver like go-sqlite3 to execute queries and manage data.

Use the database/sql package with a SQLite driver like github.com/mattn/go-sqlite3 to access SQLite databases in Go.

import (
    "database/sql"
    _ "github.com/mattn/go-sqlite3"
)

func main() {
    db, err := sql.Open("sqlite3", "./test.db")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    rows, err := db.Query("SELECT * FROM users")
    if err != nil {
        panic(err)
    }
    defer rows.Close()

    for rows.Next() {
        var id int
        var name string
        rows.Scan(&id, &name)
        println(id, name)
    }
}