A pure go package for reading sqlite3 database file.
I need to read sqlite3 database file on windows. There is an existing sqlite3 cgo binding. However a pure go version is more portable and easier to compile.
Export to csv using sqlite3 binary, e.g. write a.txt and shell out to sqlite3
.mode csv
.output data.csv
SELECT * FROM page_views LIMIT 100
sqlite3 foo.db < a.txt