github.com/ncruces/go-sqlite3 : sql: unknown driver "sqlite3" (forgotten import?) / sqlite3: no SQLite binary embed/set/loaded

ncruces-sqlite3-test.go

package main

import (
	"database/sql"
	"log"

	// We all know about this one:
	_ "github.com/ncruces/go-sqlite3"

	// solves: unknown driver "sqlite3" (forgotten import?)
	_ "github.com/ncruces/go-sqlite3/driver"

	// solves: sqlite3: no SQLite binary embed/set/loaded
	_ "github.com/ncruces/go-sqlite3/embed"
)

func main() {
	db, err := sql.Open("sqlite3", ":memory:")
	if err != nil {
		log.Fatal("open ", err)
	}
	if _, err := db.Exec(`CREATE TABLE IF NOT EXISTS foo (x TEXT)`); err != nil {
		log.Fatal("create table ", err)
	}
	if _, err := db.Exec(`INSERT INTO foo VALUES('foo')`); err != nil {
		log.Fatal("insert ", err)
	}
	x := ""
	if err := db.QueryRow(`SELECT x FROM foo`).Scan(&x); err != nil {
		log.Fatal("select ", err)
	}

	println(db, x)
}