Install without gcc (not possible) #212

techtonik · 2015-06-17T12:42:37Z

Is it possible to use the library in Go without recompiling the binaries?lxc/incus#762 (comment)

I mean is it possible to compile binary pieces of SQLite needed be go-sqlite3 and ship them in separate repository, so that only Go itself can be used to assemble the final product together? Maybe Go already provides some helpers/tools to do that?

mattn · 2015-06-17T14:31:08Z

go-sqlite3 is cgo package. so if you want to build app using go-sqlite3, you need gcc.
But if you install go-sqlite3 with go install github.com/mattn/go-sqlite, you don't need gcc.

techtonik · 2015-06-17T22:27:18Z

@mattn the repository github.com/mattn/go-sqlite doesn't exists, and go install github.com/mattn/go-sqlite3 doesn't work too:

C:\ledis>go install github.com/mattn/go-sqlite3
can't load package: package github.com/mattn/go-sqlite3: cannot find package "github.com/mattn/go-sqlite3" in any of:
        C:\Program Files\Dev\Go\src\github.com\mattn\go-sqlite3 (from $GOROOT)
        C:\ledis\src\github.com\mattn\go-sqlite3 (from $GOPATH)

mattn · 2015-06-18T00:19:46Z

once go get github.com/mattn/go-sqlite3 and do go install github.com/mattn/go-sqlite3.

techtonik · 2015-06-18T07:12:46Z

C:\ledis\src>go get github.com/mattn/go-sqlite3
# github.com/mattn/go-sqlite3
exec: "gcc": executable file not found in %PATH%

mattn · 2015-06-18T07:24:14Z

As I said in above:

go-sqlite3 is cgo package. so if you want to build app using go-sqlite3, you need gcc.
But if you install go-sqlite3 with go install github.com/mattn/go-sqlite, you don't need gcc.

techtonik · 2015-06-18T07:33:42Z

And I answered to you in #212 (comment) We are going circles.

drewwells · 2015-06-24T02:34:54Z

@techtonik once go-sqlite3 is installed, you no longer need gcc. However, you need the compiled package in your $GOPATH/pkg to do this. To do so, you need gcc to build the C dependencies of this project. ie. $GOPATH/pkg/darwin_amd64/github.com/mattn/go-sqlite3.a.

You could probably compile the archive file elsewhere and put it in the $GOPATH to forego gcc. This isn't guaranteed to work, it's much easier to compile the final program and put the binary on the system with no gcc.

arulrajalivi · 2015-06-25T15:01:17Z

@drewwells: the problem is I am able to go get the package but not able to build/install it. Its complaining about "gcc"

github.com/mattn/go-sqlite3

exec: "gcc": executable file not found in %PATH%

drewwells · 2015-06-25T15:42:37Z

@arulrajalivi what OS are you using?

arulrajalivi · 2015-06-25T16:36:49Z

Windows 64

arulrajalivi · 2015-06-25T16:37:23Z

from cygwin if I try which gcc I get
$ gcc --version
gcc (GCC) 4.9.2
Copyright (C) 2014 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.

arulrajalivi · 2015-06-25T16:38:17Z

followed this link to install gcc : http://preshing.com/20141108/how-to-install-the-latest-gcc-on-windows/

arulrajalivi · 2015-06-25T16:39:13Z

getting this from cygwin, so trying to see what to set in the %PATH%
$which gcc
/usr/bin/gcc

drewwells · 2015-06-25T16:39:26Z

Inside a cygwin window, see what go env says

CC="clang"
GOGCCFLAGS="-fPIC -m64 -pthread -fno-caret-diagnostics -Qunused-arguments -fmessage-length=0 -fno-common"
CXX="clang++"
CGO_ENABLED="1"

arulrajalivi · 2015-06-25T16:39:51Z

$ go env
set GOARCH=amd64
set GOBIN=$GOROOT\bin
set GOCHAR=6
set GOEXE=.exe
set GOHOSTARCH=amd64
set GOHOSTOS=windows
set GOOS=windows
set GOPATH=C:\Projects\Cloud Solutions
set GORACE=
set GOROOT=C:\Go
set GOTOOLDIR=C:\Go\pkg\tool\windows_amd64
set CC=gcc
set GOGCCFLAGS=-m64 -mthreads -fmessage-length=0
set CXX=g++
set CGO_ENABLED=1

arulrajalivi · 2015-06-25T19:37:31Z

after adding C:\MinGW\bin, I am getting # github.com/mattn/go-sqlite3
cc1.exe: sorry, unimplemented: 64-bit mode not compiled in. Trying to install the 64 bit version of MinGW but having trouble with that.

mattn · 2015-06-26T00:00:39Z

as the message, you need to install 64bit gcc.

kfsone · 2015-11-09T00:37:56Z

Early on mattn suggested that you could just "go install ..." but said "go-sqlite" instead of "go-sqlite3". Was this significant?

Or is mattn's last comment, that you need gcc, the absolute truth? Is there a way to install this API without gcc under windows or not?

mattn · 2015-11-09T01:04:41Z

Ah, it's my fault. :s/go-sqlite/go-sqlite3/g

smeraji · 2016-02-17T05:10:05Z

I have the exact same the problem in windows and I do not understand how Mattm last command solved the problem? what would be the compele command for go insrall?

mattn · 2016-02-17T05:14:10Z

go get -u github.com/mattn/go-sqlite3

smeraji · 2016-02-17T05:17:21Z

so in windows I get "exec gcc executable %PATH%", it's the same problme you guys discussed above I just do not understand how you resolved it

I can get the package but i can not create the binary because I do not have GCC.

mattn · 2016-02-17T05:20:39Z

go-sqlite3 is cgo package, so you need to install gcc.

smeraji · 2016-02-17T05:23:33Z

So in windows, I have to install Cygwin, build the binary and put in "GOROOT/PKG", is that what you mean?

mattn · 2016-02-17T05:41:06Z

install http://msys2.github.io/
launch mingw64_shell.bat or mingw32_shell.bat
go get -u github.com/mattn/go-sqlite3

smeraji · 2016-02-17T16:04:14Z

I still get the exact same error after following the steps you mentioned

mattn · 2016-02-17T17:15:43Z

pacman -S mingw-w64-x86_64-gcc

DominoTree · 2016-03-30T12:03:12Z

If it helps anyone, by default, msys2's Pacman seems to install gcc into C:\msys64\mingw64\bin so you'll need to add that directory to your environment PATH variable and restart your programs before gcc will work.

mattn · 2016-03-31T02:03:12Z

FYI, This is Not installable not Not using

techtonik · 2016-03-31T07:06:26Z

@mattn the users of this extension are developers, and they need to install it to use it first, and this is impossible without gcc. It is my understanding how Go stuff works. What do you mean by using if that's not the case?

mattn · 2016-03-31T07:11:25Z

If you install go-sqlite3 with go install, you can find $GOPATH/pkg/${GOOS}_${GOARCH}/github.com/mattn/go-sqlite3.a . This mean that you don't need to re-compile it if you don't update go runtime. And you can build another package using go-sqlite3 without recompiling go-sqlite3. Then I mean not installable but can use. For example, you can see debian packages that is built as binary package. But go-sqlite3 still is not published as debian package.

techtonik · 2016-03-31T08:18:25Z

This says that go install compiles code too:
https://stackoverflow.com/questions/24878737/what-is-the-difference-between-go-get-and-go-install

I am not able to validate this claim now, because:

>go get github.com/mattn/go-sqlite
# cd .; git clone https://github.com/mattn/go-sqlite E:\go\src\github.com\mattn\go-sqlite
Cloning into 'E:\go\src\github.com\mattn\go-sqlite'...
fatal: could not read Username for 'https://github.com': terminal prompts disabled
package github.com/mattn/go-sqlite: exit status 128

I guess I had enough of yak shaving for this issue. Feel free to close until better time.

mattn · 2016-03-31T08:37:59Z

go get is not same as go install

mattn · 2016-03-31T08:39:20Z

As I said in above, if you compile go-sqlite3.a with go install at once, you can uninstall gcc compiler.

tonymtz · 2016-04-02T17:41:11Z

I have the same problem on ubuntu 14.04.4 LTS, I tried this:

$ git clone https://github.com/mattn/go-sqlite3
Cloning into 'go-sqlite3'...
remote: Counting objects: 1112, done.
remote: Compressing objects: 100% (2/2), done.
remote: Total 1112 (delta 0), reused 0 (delta 0), pack-reused 1110
Receiving objects: 100% (1112/1112), 8.27 MiB | 4.93 MiB/s, done.
Resolving deltas: 100% (588/588), done.
Checking connectivity... done.

$ go install github.com/mattn/go-sqlite3
# github.com/mattn/go-sqlite3
exec: "gcc": executable file not found in $PATH

Any suggestion?

DominoTree · 2016-04-02T17:42:30Z

sudo apt-get install build-essential

dibakarmitra · 2016-08-05T07:04:05Z

having the same problem "exec: "gcc": executable file not found in $PATH" :(

mattn · 2016-08-05T07:21:22Z

@mitradibakar please read all of comments in above.

dibakarmitra · 2016-08-05T14:08:03Z

Its working fine now windows thanks to @mattn and "tdm64-gcc-5.1.0-2.exe" happy coding :)

tongxiaofeng · 2016-11-29T02:59:09Z

"tdm64-gcc-5.1.0-2.exe" is the solution.

pangliang · 2017-01-04T04:15:56Z

apt-cyg install mingw64-x86_64-gcc-g++
env CGO_ENABLED=1 GOOS=windows GOARCH=amd64 CC="x86_64-w64-mingw32-gcc" \
    go get github.com/mattn/go-sqlite3

In Cygwin will be fine.

msaron · 2017-01-18T16:51:22Z

Here are the step by step instructions.

Download and install "tdm64-gcc-5.1.0-2.exe" from http://tdm-gcc.tdragon.net/download.
Go to Program Files and click on "MinGW Command Prompt". This will start a DOS prompt with the correct environment for using MinGW with GCC.
Within this DOS prompt window, navigate to your GOPATH. For example, I went to C:\go-apps.
Enter the following commands: go get -u github.com/mattn/go-sqlite3. Then enter go install github.com/mattn/go-sqlite3
You are done! go-sqlite3 is now installed and ready for use.

sanoanalytics · 2017-01-21T16:36:32Z

msaron - Thank You!

sedentaryOne · 2017-04-04T15:01:05Z

perfect help! Thanks, everyone.

Xorton · 2018-03-05T16:14:42Z

But if you install go-sqlite3 with go install github.com/mattn/go-sqlite, you don't need gcc.

After installing i still need gcc.

go build
C:\Go\pkg\tool\windows_amd64\link.exe: running gcc failed: exec: "gcc": executable file not found in %PATH%

AndreKR · 2018-04-14T23:38:46Z

I would like to mention that this package really only needs a GCC in the PATH. No libraries, no special command prompts, nothing else.

The problem with most CGO packages is that the README says "needs GCC", but actually means something like "needs a certain version of GCC from the 32-bit build of Mingw-w64 and also this library, which you have to compile with make (but not GNU make, the other one) in an upside-down Visual Studio Command Prompt with CYGWIN_PATH_MANGLING set to MORE_MAGIC which is only available on Windows ME".

That is why I usually give up and use a different package when I see import "C", which is exactly what I did with go-sqlite3. I went through a whole zoo of embedded databases before I found out that you really just need any GCC, be it MSYS2 or TDM or Cygwin, and you just have to have it in your PATH.

cengiz7 · 2018-07-02T12:43:21Z

for linux > sudo apt install gcc
then > go get -u github.com/mattn/go-sqlite3

vkroll · 2018-10-10T09:44:05Z

I had the same problem on ubuntu:
4.15.0-36-generic #39-Ubuntu SMP Mon Sep 24 16:19:09 UTC 2018 x86_64 x86_64 x86_64 GNU/Linux
the problem seemed that ubuntu has no gcc-5 installed per default...

go install github.com/mattn/go-sqlite3
exec: "gcc-5": executable file not found in $PATH

go get -v github.com/mattn/go-sqlite3
exec: "gcc-5": executable file not found in $PATH

$sudo apt install gcc-5

then it worked

hima-del · 2021-01-21T11:23:38Z

I am using windows machine and I am getting error like

github.com/mattn/go-sqlite3

exec: "gcc": executable file not found in %PATH%

AndreKR · 2021-01-21T11:32:27Z

Which GCC have you installed and where?

dibakarmitra · 2021-01-21T16:25:15Z

Which GCC have you installed and where?

https://jmeubank.github.io/tdm-gcc/

Is working fine on windows 10 64

techtonik mentioned this issue Jun 17, 2015

Using LXD client without GCC canonical/lxd#769

Closed

techtonik changed the title ~~Using without gcc~~ Using without gcc (not possible) Mar 31, 2016

mattn changed the title ~~Using without gcc (not possible)~~ Install without gcc (not possible) Mar 31, 2016

mattn closed this as completed Aug 5, 2016

daniel-007 mentioned this issue Nov 24, 2016

windows下跑不起来 macross-contrib/vuejsto#1

Closed

MasterDimmy mentioned this issue Feb 8, 2017

sql: unknown driver "sqlite3" (forgotten import?) #335

Closed

mattn mentioned this issue Jul 11, 2017

Please implement in pure Go! #437

Closed

mattn mentioned this issue Jul 21, 2017

Install go-sqlite3 still require gcc #441

Closed

peteretelej mentioned this issue Mar 11, 2018

Update README.md with Windows Instructions go-shiori/shiori#68

Closed

Install without gcc (not possible) #212

Install without gcc (not possible) #212

Comments

techtonik commented Jun 17, 2015

mattn commented Jun 17, 2015

techtonik commented Jun 17, 2015

mattn commented Jun 18, 2015

techtonik commented Jun 18, 2015

mattn commented Jun 18, 2015

techtonik commented Jun 18, 2015

drewwells commented Jun 24, 2015

arulrajalivi commented Jun 25, 2015

github.com/mattn/go-sqlite3

drewwells commented Jun 25, 2015

arulrajalivi commented Jun 25, 2015

arulrajalivi commented Jun 25, 2015

arulrajalivi commented Jun 25, 2015

arulrajalivi commented Jun 25, 2015

drewwells commented Jun 25, 2015

arulrajalivi commented Jun 25, 2015

arulrajalivi commented Jun 25, 2015

mattn commented Jun 26, 2015

kfsone commented Nov 9, 2015

mattn commented Nov 9, 2015

smeraji commented Feb 17, 2016

mattn commented Feb 17, 2016

smeraji commented Feb 17, 2016

mattn commented Feb 17, 2016

smeraji commented Feb 17, 2016

mattn commented Feb 17, 2016

smeraji commented Feb 17, 2016

mattn commented Feb 17, 2016

DominoTree commented Mar 30, 2016

mattn commented Mar 31, 2016

techtonik commented Mar 31, 2016

mattn commented Mar 31, 2016

techtonik commented Mar 31, 2016

mattn commented Mar 31, 2016

mattn commented Mar 31, 2016

tonymtz commented Apr 2, 2016

DominoTree commented Apr 2, 2016

dibakarmitra commented Aug 5, 2016

mattn commented Aug 5, 2016

dibakarmitra commented Aug 5, 2016 • edited Loading

tongxiaofeng commented Nov 29, 2016

pangliang commented Jan 4, 2017 • edited Loading

msaron commented Jan 18, 2017 • edited Loading

sanoanalytics commented Jan 21, 2017

sedentaryOne commented Apr 4, 2017

Xorton commented Mar 5, 2018

AndreKR commented Apr 14, 2018 • edited Loading

cengiz7 commented Jul 2, 2018

vkroll commented Oct 10, 2018 • edited Loading

hima-del commented Jan 21, 2021

github.com/mattn/go-sqlite3

AndreKR commented Jan 21, 2021

dibakarmitra commented Jan 21, 2021

dibakarmitra commented Aug 5, 2016 •

edited

Loading

pangliang commented Jan 4, 2017 •

edited

Loading

msaron commented Jan 18, 2017 •

edited

Loading

AndreKR commented Apr 14, 2018 •

edited

Loading

vkroll commented Oct 10, 2018 •

edited

Loading