Good point, thanks for checking out the code! I replaced db.Query with a db.Exec...

eatonphil on May 13, 2022 | parent | context | favorite | on: SQLite in Go, with and Without Cgo

Good point, thanks for checking out the code! I replaced db.Query with a db.Exec for the SELECT count (just to avoid the row iteration/deserialization) and I'm seeing closer performance.

I'll post an update and credit you.