Yes SQLite is not really designed for concurrent use and then as the article mentions requires cgo. I think it might handle concurrent access but not writes. PostgreSQL is a great choice with good Go support if you're looking for a solid relational db, but of course has to be run separately. One other project I'd like to explore is https://github.com/cznic/ql a pure Go sql db, not sure how complete but it looks interesting, like a pure Go SQLite.
A side comments to "go sqlite3 package". it is really hard to do concurrent writing or even sequencial writing.
A lot of "database locked" errors I found. (trust me I tried really hard to make writing in sync.)
btw: boltDB is cool. thanks for sharing.
What caused the database locked errors?
Yes SQLite is not really designed for concurrent use and then as the article mentions requires cgo. I think it might handle concurrent access but not writes. PostgreSQL is a great choice with good Go support if you're looking for a solid relational db, but of course has to be run separately. One other project I'd like to explore is https://github.com/cznic/ql a pure Go sql db, not sure how complete but it looks interesting, like a pure Go SQLite.