Fun with SQLite3 and Go


music: INXS – greatest hits, Jethro Tull – Crest of the Knave, Meatloaf – Dead Ringer

I created the new tables and started writing a conversion of existing data. But, from the dept of nothing can ever be easy, Sqlite3 does not play well with others. I am not talking about multiple apps accessing the database. Within the same function. I tried closing everything as I used it It is easy to lock yourself out. I have the current data in a table called “imported”. I wanted to use a cursor and then loop through it and do the inserts into the household and members tables. I think trying to hold the dataset open and do inserts at the same time was causing the problem of a database is locked error. I still needed to loop through the import data and split the it up between the tables. I could not easily use SQL to do it. I need to create the IDs and and use the household ID as a FK in members. Since this part of the app is a one off and will not need to be maintained I just brute forced it by putting the import data into arrays. Then I could loop through the arrays and do the inserts. Now I have test data.


I watched another lecture Great Courses- Our Night Sky. This one covered the planets.

I finished the book “Supermen – The First Wave of Comic Book Heroes 1936-1941. It had several pages of notes at the end that I think would have made more sense to put as an intro to each story. This would have given the now strange stories context and history.

I have finished another book – A Canticle for Leibowitz by Walter M. Miller Jr. This book is was used as inspiration for the Fallout series of games. It takes place in the far future after a nuclear war. The people of the world are basically put back to the bronze age, but a group of monks try to keep safe the little bits of documents concerning technology.

I started Pale Blue Dot A Vision of the Human Future in Space by Carl Sagan.
Here is a link to the famous NASA photo – pale blue dot.