Resolve go-sqlite3 requires cgo to work on Windows system

Nov 1, 2024#Go87

AI Translation

This post is translated from Chinese into English through AI.View Original

AI-generated summary

When using go-sqlite3 to connect to an SQLite database on Windows, an error occurs because the binary was compiled with 'CGO_ENABLED=0', and go-sqlite3 requires cgo. This issue arises because Windows does not have gcc installed by default, preventing cgo from functioning. The solution is to install mingw to obtain gcc. This can be done easily using the scoop package manager with the commands `scoop bucket add main` and `scoop install main/mingw`. After installation, you can verify gcc is installed successfully by running `gcc -v`.

Introduction#

When using go-sqlite3 to connect to the sqlite database on Windows systems, the project runs into an error, and the error message is as follows:

Binary was compiled with 'CGO_ENABLED=0', go-sqlite3 requires cgo to work. This is a stub

Cause of the Problem#

The Windows system does not have gcc installed by default, so cgo cannot work.👆🤓

Solution#

Windows systems can obtain gcc by installing mingw.😡

Minimalistic GNU for Windows is a runtime environment for GCC, GDB, make and related binutils.

I directly used scoop for one-click installation, entering the following commands in the terminal:

scoop bucket add main

scoop install main/mingw

After running the above commands, test whether gcc is installed successfully.

gcc -v

🆗, this completes the task.