Show HN: Sqinn-Go is a Golang library for accessing SQLite databases in pure Go

1. sqlite

   1 74 - -

   No, but that has the disadvantage of being C compiled into Go, then being compiled into native executable.

   I'm actually surprised by how readable this came out; props to the Go->C compiler author. But you can guess that pushing this sort of thing through the Go compiler is going to cause some slowdowns due to sheer paradigm mismatch: https://gitlab.com/cznic/sqlite/-/blob/master/lib/sqlite_lin...

2. Stream

   getstream.io featured

   Stream - Scalable APIs for Chat, Feeds, Moderation, & Video. Stream helps developers build engaging apps that scale to millions with performant and flexible Chat, Feeds, Moderation, and Video APIs and SDKs powered by a global edge network and enterprise-grade infrastructure.

   

3. Sqinn-Go

   2 8 450 5.5 Go

   Golang SQLite without cgo

   

4. libc

   3 4 - -

   I don't think I understand what the argument for that is, because I've only ever heard it articulated as "cgo isn't go" which doesn't really convey much information.

   Is this go? https://gitlab.com/cznic/libc/-/blob/master/libc_openbsd.go?...

   I mean technically I suppose it is code that conforms to the go language grammar, but I'm not sure why a language purist would accept this.

5. homebrew-musl-cross

   4 3 620 4.3 Ruby

   Homebrew Formula for static-friendly musl-based GCC macOS-to-Linux cross-compilers

   

   Or with musl-cross:

   https://github.com/FiloSottile/homebrew-musl-cross

   It works pretty well! It's a thing you might keep in your back pocket to test builds from your ARM dev machine on a dev host, and then let the CI/CD system build the real version later.

6. go-sqlite-bench

   5 4 418 4.3 Go

   Benchmarks for Golang SQLite Drivers

   

   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

7. gosqlite

   6 1 38 2.7 C

   SQLite driver for the Go programming language

   

   I think it's a somewhat unfair (though who cares if it's unfair) comparison because you aren't using the database/SQL interface and mattn does.

   If you drop that interface, you get much better performance.

   See: https://github.com/eatonphil/gosqlite for example.

8. go-sqlite3

   7 42 739 9.6 Go

   Go bindings to SQLite using wazero (by ncruces)

   

9. InfluxDB

   www.influxdata.com featured

   InfluxDB – Built for High-Performance Time Series Workloads. InfluxDB 3 OSS is now GA. Transform, enrich, and act on time series data directly in the database. Automate critical tasks and eliminate the need to move data externally. Download now.

   

10. wazero

    8 57 5,484 8.1 Go

    wazero: the zero dependency WebAssembly runtime for Go developers

    

    It is slower.

    The WASM runtime wazero [1] uses a compiler on amd64 and arm64 (on Linux, macOS, Windows, and FreeBSD), but the current compiler is very fast (at compiling), but very naive (generates less than optimal code).

    An optimizing compiler is currently being developed, and should be released in the coming months. I'm optimistic that this compiler will cover the performance gap between WASM and modernc.

    [1]: https://wazero.io

11. sqinn

    9 4 88 5.5 C

    SQLite over stdin/stdout

    

12. purego

    10 27 2,812 7.4 Go

    

Suggest a related project