Resolving go-sqlite3 requires cgo to work on Windows systems

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 a SQLite database on Windows, an error occurs because the binary was compiled with 'CGO_ENABLED=0', which requires cgo to function. The issue arises because Windows does not have gcc installed by default, preventing cgo from working. The solution is to install mingw, which provides 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`.

Preface#

When using go-sqlite3 to connect to the sqlite database on Windows, 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#

The Windows system 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.