sqlite3 transactions?

Question

go

Help defeat these damn goroutines and sqlite)
After working out, the code does not produce all 100 records,
40% of the records are lost and Rollback occurs.

https://play.golang.org/p/TpaZ2Bk_mwH

Answer 1

1. there should be one transaction, not 100
2. after the loop, you need to wait until all goroutines are completed (using sync.WaitGroup or channel).