Skip to content

Go SDK v0.14.0

Choose a tag to compare

@github-actions github-actions released this 11 Jun 20:43
· 5 commits to main since this release
3fa2d9b
go get github.com/joaoh82/rust_sqlite/sdk/go@v0.14.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.14.0-linux-x86_64.tar.gz
  • sqlrite-ffi-v0.14.0-linux-aarch64.tar.gz
  • sqlrite-ffi-v0.14.0-macos-aarch64.tar.gz
  • sqlrite-ffi-v0.14.0-windows-x86_64.tar.gz

Extract for your platform, then point cgo at it:

tar xzf sqlrite-ffi-v0.14.0-<platform>.tar.gz
export CGO_CFLAGS="-I$(pwd)/sqlrite-ffi-v0.14.0-<platform>/include"
export CGO_LDFLAGS="-L$(pwd)/sqlrite-ffi-v0.14.0-<platform>/lib -lsqlrite_c"
export LD_LIBRARY_PATH="$(pwd)/sqlrite-ffi-v0.14.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.14.0 for the full changelog.

What's Changed

  • docs(release): bump displayed version to 0.13.0 (site + install snippets) by @joaoh82 in #163
  • feat(sql): aggregates / GROUP BY / DISTINCT / HAVING over JOIN results (SQLR-6) by @joaoh82 in #164
  • chore(playground): refresh vendored WASM bundle with SQLR-6 engine by @joaoh82 in #165
  • fix(sql): error on unknown columns in single-table scope (SQLR-2) by @joaoh82 in #166
  • fix(sql): validate table qualifiers in single-table scope (SQLR-14) by @joaoh82 in #167
  • fix(sql): validate table qualifiers in FTS function column args (SQLR-15) by @joaoh82 in #168
  • Release v0.14.0 by @github-actions[bot] in #169

Full Changelog: sdk/go/v0.13.0...sdk/go/v0.14.0