How to use modernc/sqlite driver

[bbkane]

Hello - I'd like to use https://pkg.go.dev/modernc.org/sqlite for my SQLite driver (it's CGO free!). Is this possible, and if it's not currently possible, do you think it's a good idea / fairly easy for me to make a PR to add it?

[xiam]

Oh! CGO-free, that's good news. We've recently replaced the PostgreSQL driver, it was not that straightforward because PostgreSQL offers many different features and types (like JSON, ARRAY, etc). sqlite offers less features in comparison, so replacing the driver should be less complicated. This sounds useful, it would be a great idea and a valuable addition if you could create a PR for this.

[mfridman]

Fwiw we recently switched the sqlite driver in goose in favor of this modernc.org/sqlite library and it has been working nicely.

The folks maintaining it also are fairly active in Gophers slack #sqlite channel.