Phil Eaton • 5/12/2022

SQLite in Go, with and without cgo

This technical article benchmarks and compares the performance of two Go SQLite libraries: the popular cgo-based mattn/go-sqlite3 and the pure-Go modernc.org/sqlite translation. It details ingest (INSERT) and query (SELECT) benchmarks on varying dataset sizes, finding the pure-Go version is 10% to 100% slower, and discusses the trade-offs between compatibility, performance, and the use of cgo.

0 comments

#sqlite #database #benchmark