Go SDK v0.11.0

go get github.com/joaoh82/rust_sqlite/sdk/go@v0.11.0

package main

import (
    "database/sql"
    "fmt"

    _ "github.com/joaoh82/rust_sqlite/sdk/go"  // registers "sqlrite" driver
)

func main() {
    db, _ := sql.Open("sqlrite", ":memory:")
    defer db.Close()

    _, _ = db.Exec("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
    _, _ = db.Exec("INSERT INTO users (name) VALUES ('alice')")

    rows, _ := db.Query("SELECT id, name FROM users")
    defer rows.Close()
    for rows.Next() {
        var id int64
        var name string
        rows.Scan(&id, &name)
        fmt.Printf("%d: %s\n", id, name)
    }
}

Prebuilt libsqlrite_c (cgo dependency)

The Go binding uses cgo against the libsqlrite_c shared library shipped by sqlrite-ffi. The tarballs attached below are the same ones from this release wave's C FFI release — provided here so Go users have a one-stop-shop:

• sqlrite-ffi-v0.11.0-linux-x86_64.tar.gz
• sqlrite-ffi-v0.11.0-linux-aarch64.tar.gz
• sqlrite-ffi-v0.11.0-macos-aarch64.tar.gz
• sqlrite-ffi-v0.11.0-windows-x86_64.tar.gz

Extract for your platform, then point cgo at it:

tar xzf sqlrite-ffi-v0.11.0-<platform>.tar.gz
export CGO_CFLAGS="-I$(pwd)/sqlrite-ffi-v0.11.0-<platform>/include"
export CGO_LDFLAGS="-L$(pwd)/sqlrite-ffi-v0.11.0-<platform>/lib -lsqlrite_c"
export LD_LIBRARY_PATH="$(pwd)/sqlrite-ffi-v0.11.0-<platform>/lib"
go build ./...

(On macOS use DYLD_LIBRARY_PATH instead of LD_LIBRARY_PATH. On Windows, place the .dll next to your binary or on %PATH%.)

See the umbrella release v0.11.0 for the full changelog.

What's Changed

• SQLR-42 — WASM in-browser SQL playground (/playground) by @joaoh82 in #149
• SQLR-43 — Go edge/IoT event collector (concurrent-writes showcase) by @joaoh82 in #150
• SQLR-10 — honor CREATE TABLE IF NOT EXISTS + queryable sqlrite_master + PRAGMA table_list by @joaoh82 in #151
• fix(release): bump sqlrite-journal example in bump-version.sh (unblocks 0.11.0) by @joaoh82 in #152
• Release v0.11.0 by @github-actions[bot] in #153

Full Changelog: sdk/go/v0.10.2...sdk/go/v0.11.0