sqinn
go-sqlite-bench
sqinn | go-sqlite-bench | |
---|---|---|
4 | 2 | |
74 | 234 | |
- | - | |
7.0 | 6.8 | |
about 1 month ago | about 1 month ago | |
C | Go | |
The Unlicense | The Unlicense |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
sqinn
-
Show HN: My Go SQLite driver did poorly on a benchmark, so I fixed it
First part of the README that hasn't changed in 2 months:
> Sqinn-Go is a Go (Golang) library for accessing SQLite databases without cgo. It uses Sqinn https://github.com/cvilsmeier/sqinn under the hood. It starts Sqinn as a child process (os/exec) and communicates with Sqinn over stdin/stdout/stderr. The Sqinn child process then does the SQLite work.
> If you want SQLite but do not want cgo, Sqinn-Go can be a solution.
This seems pretty clear to me about what's happening. It makes an OS call to a third-party executable (sqinn), pipes the result from stdout back into the Go code. The advantage is you don't have to compile the C code alongside your Go code.
Honestly, I don't really know how much more clear the author could be. I guess if you don't know what stdin, stdout, and stderr are it might be confusing? It's hard to imagine that a programmer who is interested in this library isn't familiar with those concepts though.
- Show HN: Sqinn-Go is a Golang library for accessing SQLite databases in pure Go
-
SQLite in Go, with and Without Cgo
I've not used it, but sqinn is one sqlite server meant specifically to be used by languages without c calling conventions:
https://github.com/cvilsmeier/sqinn
-
SQLite in Go, with and without cgo
The latest supported version is 3.38.3: https://github.com/cvilsmeier/sqinn/releases/tag/v1.1.15
go-sqlite-bench
-
Show HN: Sqinn-Go is a Golang library for accessing SQLite databases in pure Go
Sqinn author here. Nothing against CGO, but I develop/deploy on Win/Linux, and cross-compiling CGO is very painful. Regarding performance: To my own surprise, Sqinn out-performs mattn (and others) for normal workloads, see https://github.com/cvilsmeier/sqinn-go-bench
-
SQLite in Go, with and without cgo
If you want to avoid cgo, consider sqinn as well: benchmarks.
What are some alternatives?
go-sqlite3 - Go bindings to SQLite using wazero
homebrew-musl-cross - Homebrew Formula for static-friendly musl-based GCC macOS-to-Linux cross-compilers
tcl
gosqlite - SQLite driver for the Go programming language
drydock - Experiment in unit testing with PostgreSQL using Docker
sqlite
Sqinn-Go - Golang SQLite without cgo
go - The Go programming language
wazero - wazero: the zero dependency WebAssembly runtime for Go developers