Review other potential replacements for mattn/go-sqlite3 package

[atc0005]

Potential candidates:

• https://pkg.go.dev/crawshaw.io/sqlite
• https://pkg.go.dev/modernc.org/sqlite
• https://pkg.go.dev/gitlab.com/cznic/sqlite
  • https://gitlab.com/cznic/sqlite
• https://github.com/zombiezen/go-sqlite
  • 1.0 version released 2023-12-07

Why?

The mattn/go-sqlite3 package seems to work well thus far, but it requires CGO for building and some Go developers like to avoid CGO where they can. I'm still new enough and have ready access to a CGO-compatible build environment that it's not an issue for me, but it's probably still worth exploring to see what benefits these other packages might provide.

[atc0005]

Why?

The mattn/go-sqlite3 package seems to work well thus far, but it requires CGO for building and some Go developers like to avoid CGO where they can. I'm still new enough and have ready access to a CGO-compatible build environment that it's not an issue for me, but it's probably still worth exploring to see what benefits these other packages might provide.

#48 and #53 says that it definitely was an issue for me.

[atc0005]

FWIW: It takes about 10 minutes to build a new release using the docker Makefile recipe.

ubuntu@ubuntu-1804-virtual-machine:~/Desktop/mysql2sqlite$ time make docker
Removing object files and cached files ...
Removing any existing release assets
Building (static) release assets for windows x86 ...
Building mysql2sqlite 386 binaries
Generating mysql2sqlite x86 checksum files
Building check_mysql2sqlite 386 binaries
Generating check_mysql2sqlite x86 checksum files
Completed (static) release assets build tasks for windows x86
Building (static) release assets for linux x86 ...
Building mysql2sqlite 386 binaries
Generating mysql2sqlite checksum files
Building check_mysql2sqlite 386 binaries
Generating check_mysql2sqlite checksum files
Completed (static) release assets build tasks for linux x86
Building (static) release assets for windows x64 ...
Building mysql2sqlite amd64 binaries
Generating mysql2sqlite checksum files
Building check_mysql2sqlite amd64 binaries
Generating check_mysql2sqlite checksum files
Completed (static) release assets build tasks for windows x64
Building (static) release assets for linux x64 ...
Building mysql2sqlite amd64 binaries
Generating mysql2sqlite checksum files
Building check_mysql2sqlite amd64 binaries
Generating check_mysql2sqlite checksum files
Completed (static) release assets build tasks for linux x64
Completed all cross-platform builds via Docker containers ...

real	9m58.547s
user	0m0.157s
sys	0m0.224s

[atc0005]

• https://pkg.go.dev/modernc.org/sqlite

The docs indicate that Windows is not yet supported.

[atc0005]

• https://pkg.go.dev/crawshaw.io/sqlite

From the docs:

This is not a database/sql driver.

Sure enough, the API doesn't (appear to) match up, so I'd need to rework the current codebase appropriately.

[atc0005]

• https://pkg.go.dev/modernc.org/sqlite

The docs indicate that Windows is not yet supported.

Looks like official Windows support was added in v1.14.0 (2021-11-13).

[atc0005]

https://github.com/zombiezen/go-sqlite recently hit 1.0 status.

From the README:

This package provides a low-level Go interface to SQLite 3. It is a fork of crawshaw.io/sqlite that uses modernc.org/sqlite, a CGo-free SQLite package. It aims to be a mostly drop-in replacement for crawshaw.io/sqlite.

This package deliberately does not provide a database/sql driver. See David Crawshaw's rationale for an in-depth explanation. If you want to use database/sql with SQLite without CGo, use modernc.org/sqlite directly.