doranwen | Geek skills galore and Yahoo Groups

This last week or so has seen a major increase in my geek skills.

A week ago yesterday, I wrote my first Python script (to create a macro using the library pyAutoGui). Then I wrote several shell scripts to automate some processing of things for that project.

And then it worked out that

arcadianmaggie did not have the time to set up the next stage in dealing with Yahoo Groups data (identifying fandoms and setting up a database to put the info into it)… so I learned how to use postgreSQL and pgAdmin4 and quite a bit more SQL, and I now have all of the spreadsheets I created (the Yahoo Groups Metadata that was uploaded to the IA) into a database I can work with. (I also found a few errors I need to fix in that upload at some point - they're fixed in the db.)

So now I'm currently prepping a spreadsheet of tasks that volunteers can do, using a SQL query to pull the necessary info on all the groups from the database. I have a few tabs to get ready before I can link it publicly…