Category Archives: MySQL

Where Were These Resources Weeks Ago?

After learning about IndexedDB in the GrowWithGoogle Mobile Web course, I’m enhancing my big personal project to create a local backup of the MySQL database using IndexedDB with PHP and jQuery If only I’d been aware of this “Google Search” … Continue reading

Posted in Databases, JavaScript, MySQL, Offline First, PHP | Tagged , | Leave a comment

Self-Doubt Pays Off

TIL (Theotherday I Learned) That Word “Group” Doesn’t Mean What You Think It Means. Here’s my schema so you can follow what I was trying to do. My database gathers data I collect using the Spotify Web API on the popularity … Continue reading

Posted in MySQL, Spotify | Tagged | Leave a comment

From Excel to MySQL Mess

Here are my candidates in Excel: The CSV file in VS Code: My import command and … the mess I can’t figure out (and immediately deleted): WHAT happened? Attempt #2 I surrounded everything with single quotes and … Note it … Continue reading

Posted in MySQL | Tagged | Leave a comment

My Second Schema Revising

“Hmm …” he says, realizing he’ll want data viz for multiple elections and many candidates run in multiple elections … and sometimes they change parties … Where should the year go? Where the party at? Oh, man … the number … Continue reading

Posted in Databases, Elections, myProjects, MySQL | Tagged | Leave a comment

My Second Schema

Last time I really worked with results from the 2016 Presidential Election was recorded for posterity in a post from December 2016. Politico never did bother to finish entering complete election results so I’ve been waiting for the FEC to … Continue reading

Posted in Data Visualization, Elections, MySQL | Leave a comment

What I’m Proud Of

So, I have a B.A. from one university and I completed 10 of 12 classes toward a Master’s (I stopped going when my former employer stopped paying) at another but I never put a bumper sticker on my car for … Continue reading

Posted in myLearning, MySQL | Tagged | Leave a comment

Fine. One bite and baby step at a time.

Tasks Script gets Artist Name and ID from Spotify and puts into artist table that stores IDs and Names. Script gets Artist(s) popularity for day one and puts it into artistPop table that has, in each row: a datetime stamp, artist id, and … Continue reading

Posted in Databases, MySQL, Spotify | Leave a comment