Use pure-go sqlite lib

[gsxhnd]

Describe the feature

github.com/mattn/go-sqlite3 this lib using c, cgo is not support CROSS_COMPILE

Motivation

[cure]

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

[axetroy]

cgo is really annoying

[jmwielandt]

+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%

[rittneje]

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.

[jinzhu]

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