Go port of SQLite without CGo

• sqlite

  72 - -

I've been using this for one of my personal projects (https://dmd.tanna.dev) to simplify the cross-compilation process and so far it's been very good.

When I noticed the SHA3 extension was missing (https://gitlab.com/cznic/sqlite/-/issues/139) it was noted it could be very easily patched client-side which is handy, as well as adding functionality into the core library to handle it.

• libc

  4 - -

• InfluxDB

  www.influxdata.com sponsored

  Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

  

• ctlstore

  3 258 6.2 Go

  Control Data Store

  

at segment we benchmarked https://github.com/segmentio/ctlstore against this driver. We saw about a 50% hit to read performance, so we didn't move forward with it, but the improvements in service build times were really appealing.

• sysroot

  2 19 3.3 C

  Files for cross-compilation

  

• ClickHouse

  208 34,153 10.0 C++

  ClickHouse® is a free analytics DBMS for big data

  

• go-sqlite3

  21 265 9.5 Go

  Go bindings to SQLite using wazero (by ncruces)

• go-sqlite

  4 541 5.2 Go

  pure-Go SQLite driver for Go (SQLite embedded) (by glebarez)

How does this compare to https://github.com/glebarez/go-sqlite ?

Using that for https://www.octobench.com/ and I'm very happy.

• WorkOS

  workos.com sponsored

  The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

  

• sqlite

  3 516 7.1 Go

  The pure-Go SQLite driver for GORM (by glebarez)

Each call out to a C library from Go locks an OS thread rather than participating in the go routine scheduling. If stuff happens that makes those threads slow or have some issue, they just sit here. I had a server with C Kafka libraries and each time the network glitched the CPU would spike up wards and not decline. With pure go the scheduler is able to just swap out and ignore code that is stuck some where (unless it were in a busy loop).

With this SQLite implementation I can stick it in my server (as a background, near real time mirror of memory state to disk) without worrying that the main loop will get clogged or my real time path will be hurt.

I use glabarez’ wrapper which makes it have an API like other Go databases: https://github.com/glebarez/sqlite/ and hey have been very responsive to issues I raised.

I have been running load tests against it for a few weeks, and it is quite solid.

• osxcross

  23 2,731 5.5 C++

  Mac OS X cross toolchain for Linux, FreeBSD, OpenBSD and Android (Termux)

Suggest a related project