Ways of making it CGO free

[lispyclouds]

As of now the sqlite lib we use needs CGO_ENABLED="1" and that causes us to care about the OS it builds on, how to run tests and actually see if this all works in every target OS.

This tracks ways of making it CGO free and eliminate these issues if/when the need arises.

Using https://gitlab.com/cznic/sqlite

This seems to be the most widely used non CGO lib and claims to be fully SQLite spec complaint and passing all their tests

Patch:

diff --git a/main.go b/main.go
index b77fab4..e7a9cb0 100644
--- a/main.go
+++ b/main.go
@@ -11,8 +11,8 @@ import (
    "database/sql"

    "github.com/babashka/pod-babashka-go-sqlite3/babashka"
-   _ "github.com/mattn/go-sqlite3" // Import go-sqlite3 library
    "github.com/russolsen/transit"
+   _ "modernc.org/sqlite" // Import go-sqlite3 library
 )

 func debug(v interface{}) {
@@ -162,7 +162,7 @@ func processMessage(message *babashka.Message) {
            return
        }

-       conn, err := sql.Open("sqlite3", db)
+       conn, err := sql.Open("sqlite", db)
        if err != nil {
            babashka.WriteErrorResponse(message, err)
            return

This passes all our tests. We need to run go mod tidy to reconcile all the deps when adding this and will bump up the min Go version to 1.21.

[lispyclouds]

#26