failed to initialize database, got error Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub #6095

donhuvy · 2023-02-23T09:55:17Z

donhuvy
Feb 23, 2023

I am learning gorm, with authoritative document at https://gorm.io/docs/index.html

File vy_sqlite.go

package main

import (
	"gorm.io/driver/sqlite"
	"gorm.io/gorm"
)

type Product struct {
	gorm.Model
	Code  string
	Price uint
}

func main() {
	db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
	if err != nil {
		panic("failed to connect database")
	}

	// Migrate the schema
	db.AutoMigrate(&Product{})

	// Create
	db.Create(&Product{Code: "D42", Price: 100})

	// Read
	var product Product
	db.First(&product, 1)                 // find product with integer primary key
	db.First(&product, "code = ?", "D42") // find product with code D42

	// Update - update product's price to 200
	db.Model(&product).Update("Price", 200)
	// Update - update multiple fields
	db.Model(&product).Updates(Product{Price: 200, Code: "F42"}) // non-zero fields
	db.Model(&product).Updates(map[string]interface{}{"Price": 200, "Code": "F42"})

	// Delete - delete product
	db.Delete(&product, 1)
}

log

API server listening at: 127.0.0.1:62919
WARNING: undefined behavior - version of Delve is too old for Go version 1.20.1 (maximum supported version 1.19)

2023/02/23 16:51:11 C:/Users/admin/GolandProjects/awesomeProject1/vy_sqlite.go:15
[error] failed to initialize database, got error Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub

How to fix it?

https://stackoverflow.com/questions/75543150/failed-to-initialize-database-got-error-binary-was-compiled-with-cgo-enabled-0

DilyaraKaz · 2023-05-03T15:08:18Z

DilyaraKaz
May 3, 2023

where answeer beach

0 replies

Frier03 · 2023-05-18T20:47:10Z

Frier03
May 18, 2023

Set the CGO_ENABLED to 1. go-sqlite3 requires cgo to work!

You can set the variable using $env:CGO_ENABLED=1

4 replies

JoyCood Nov 3, 2023

i set the CGO_ENABLED=1, but it's still not work.

nccapo Dec 28, 2023

i set CGO_ENABLED to 1, but still have same issue

zhangyiming748 Dec 30, 2023

me too

clabnet Apr 24, 2024

me too

matiasdev30 · 2023-12-09T19:27:01Z

matiasdev30
Dec 9, 2023

sames issues here

0 replies

zhangyiming748 · 2023-12-13T01:35:59Z

zhangyiming748
Dec 13, 2023

install build-essential and libsqlite3-dev

sudo apt-get install build-essential libsqlite3-dev

This is how I solved it

0 replies

nccapo · 2023-12-28T19:24:50Z

nccapo
Dec 28, 2023

First of all check CGO_ENABLED value: go env CGO_ENABLED
Then try to update it using: go env -w CGO_ENABLED=<0 or1>

Source: https://forum.golangbridge.org/t/getting-errors-when-running-go-project-that-uses-github-com-mattn-go-sqlite3-library/31800

1 reply

zhangyiming748 Dec 30, 2023

thanks

ngshiheng · 2024-02-03T13:00:22Z

ngshiheng
Feb 3, 2024

If anyone is currently working with Dockerfile and has encountered a similar issue, I found that adding the following lines to my Dockerfile resolved the problem (ref):

FROM golang:1.21-alpine AS go-builder
ENV CGO_ENABLED=1
RUN apk add --no-cache gcc musl-dev
RUN go build -ldflags='-s -w -extldflags "-static"' -o /bin/mym ./cmd/mym
# ...

I found this solution by referring to the Dockerfile in the go-sqlite3 repo

2 replies

dkrest1 Feb 6, 2024

it took so long to build

dkrest1 Feb 6, 2024

but it work

Chenorlive · 2025-05-20T20:47:15Z

Chenorlive
May 20, 2025

hello

if yow are on window see this error
Install gcc complier
add to environment variable
restart your terminal
go run

if not okay
run $env:CGO_ENABLED=1
go run .

0 replies

Uh oh!

failed to initialize database, got error Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub #6095

Uh oh!

Replies: 7 comments · 7 replies

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Uh oh!

Replies: 7 comments 7 replies