Use pure-go sqlite lib about sqlite HOT 5 CLOSED

"modernc.org/sqlite" doesn't pass our tests, would consider making the change if there are any other choices.

from sqlite.

This library may be a good candidate: http://modernc.org/sqlite (cgo-free).

from sqlite.

cgo is really annoying

from sqlite.

+inf!!

I can't use it on windows. It throws me this error:

PS > go get -u gorm.io/driver/sqlite
# github.com/mattn/go-sqlite3
cgo: C compiler "gcc" not found: exec: "gcc": executable file not found in %PATH%

from sqlite.

Just to clarify some points here:

1. cgo supports cross-compilation. However you need a proper C cross-compiler for it to work. It's admittedly non-trivial, but not impossible. You may also be able to leverage docker to make this simpler.
2. cgo is supported on Windows. But again, you need a C compiler. From what I hear, MinGW usually works well.
3. Using a C-to-Go transpiled library is not without risk. So it might be nice to give people a choice, either via a separate module, or via a build tag.

from sqlite.