Migrate: Support sqlite in released CLI

[dhui]

Currently, SQLite is not built into the release CLI.

It means that SQLite is not officially supported by migrate since it's not in our test suite. This is due to issues with cross-compiling and CGO. mattn/go-sqlite3, the most popular sqlite driver and only one that is included in the compatibility test, requires cgo. In fact, it looks like all golang sqlite drivers require cgo at this time.

References:

• https://github.com/golang-migrate/migrate/commit/15611d4559ac626305655c5b2fa18b2cfe995f60
• https://github.com/mattes/migrate/issues/165
• https://github.com/mattes/migrate/issues/244
• https://github.com/mattes/migrate/pull/238

So if you want to use sqlite with the migrate CLI, you'll need to build it yourself or use the docker image.

[turboMaCk]

hello, @dhui does this mean that SQLite is currently not supported by CLI tool?

[dhui]

I've updated the issue description, which will hopefully answer your question.

[dhui]

In theory, the docker builds could support sqlite since there's no need to cross-compile

[verdverm]

https://github.com/karalabe/xgo might have a docker based solution already