Spent some well used time looking at Julia docs on SQLite. I wish I could say I just read the docs and knew exactly what to do. The docs did help but a lot of playing (trial and error) was just as important to finally get a working Julia/SQLite program. However my history with this module isn't very good. Of course in hindsight it doesn't look too hard. But I never did find a small working program which would have made everything much simpler, just pieces of code that wasn't obvious how to connect. I mean in a mere 30 lines of code I have the necessary pieces to accomplish a lot using Julia/SQLite. Although I think playing with pandas and dataframes in Python helped me get a better perspective to using it in Julia, because Julia also uses dataframes. My goal was simply to get it to work so I don't understand everything I did following some examples I saw in the docs, for example...
df=DBInterface.execute(db::SQLite.DB, sql::String) |> DataFrame
"|> DataFrame"...what the heck?
I mean it's not hard to infer. But the syntax is strange to me.
I took about a 9 month break from Julia, kind of excited to start working with it again.