Benchmarking SQLite Performance in Go. Using Go's awesome built-in simple benchmarking tools to investigate SQLite database performance in a couple of different benchmarks, plus a comparison to Postgres.

This page summarizes the projects mentioned and recommended in the original post on /r/golang

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • sqlite

    I understand, but first and last sentence of any article - that's what catching people (usually). BTW, thanks for nice test cases! I would also add to tests CGO free plain sqlite implementation in Go that helps make truly independent Go programs

  • go-sqlite-bench

    Benchmarking Go + SQLite (by kalafut)

    I didn't want to add more complexity to the article with a different driver. Have a look at https://github.com/kalafut/go-sqlite-bench for some experiments with that.

  • InfluxDB

    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.

  • Hey

    HTTP load generator, ApacheBench (ab) replacement (by rakyll)

    64 concurrent requests isn't a lot. Modern web apps can typically handle much more than that (depending on what the request does, of course). Try it yourself with a load tester like https://github.com/rakyll/hey against a Go HTTP server, for example the one I've built in https://www.golang.dk/articles/go-and-sqlite-in-the-cloud

  • go-bench2csv

    A small CLI to parse the output of go test -bench and output to CSV.

    Benchmark output to CSV: https://github.com/maragudk/go-bench2csv

  • sqlite-benchmark

    Companion repo for "Benchmarking SQLite Performance in Go" (by maragudk)

    I'm actually working on that, but having trouble with write parallelism erroring. See the branch here: https://github.com/maragudk/sqlite-benchmark/tree/modernc

  • WorkOS

    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.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts