Conversion to a Pure Golang implementation of SQLite

[Ahbrown41]

Describe the feature

The feature which I am happy to do a PR for is to remove the use of the existing CGO based SQLite implementation with a pure Golang based implementation here.

• https://github.com/zombiezen/go-sqlite

Motivation

The CGO libraries are a HUGE pain with Windows machines and even other machines without the GCC binaries and specific settings. It does not compile well in many scenarios. This conversion appears to be solid and is a direct conversion of the C libraries of the original implementation.

Related Issues

[rittneje]

As I mentioned here, switching drivers is a breaking change. #72 (comment)

[WinXaito]

Maybe create a new driver ? Like sqlite-go or gosqlite.

Because the CGO requirement is really akward

[glebarez]

have you tried https://github.com/glebarez/sqlite

[Elara6331]

This can be done relatively easily using Go's tags to switch between drivers. modernc.org/sqlite contains a near drop-in replacement of the current driver. I've done this locally and will submit a PR shortly, regardless of if it gets merged.