Archive for January, 2017

Using MySQL as a time series database to track my podcasts

January 30th, 2017 | Category: analytics

In my previous blog post I covered how I used InfluxDB and Grafana to do analytics on my podcast backlog reaching the depressing conclusion that I wasn’t in fact making progress on my backlog. Oh my. If you look carefully though you’ll also note that the time series used ranged from the 15th February 2016 to the 22nd September 2016. One might have also noticed that in the graph close ups there were these unusually straight lines which whilst not visible to you were actually gaps in the data where Grafana was connecting the dots. There were actually a couple of these points and they were periods where InfluxDB for what ever reason hadn’t started. The final reason it ends in September was that InfluxDB at the time was refusing to start and until I got around to writing the blog post had been dead. Instead in late November 2016 I decided to try something different: to use MySQL as a time series database instead!

Read more

No comments

Apple’s Courage

January 23rd, 2017 | Category: apple,macosx,thoughts

Apple said it took “courage” to take away the 3.5mm headphone jack from the iPhone 7. And then none of this courage was on display with the MacBookPro that removes the USB ports, the Thunderbolt 2 ports, MagSafe port and SD card slot to replace them with four USB-C ports…and left the 3.5mm headphone jack there. What?

Instead of taking the chance with the iPhone 7 to converge on USB-C for the connectivity, Apple decided to stick with Lightening. I was also mildly annoyed that when they moved from the old 30 pin connector they went to Lightening but it was obvious there were some advantages over the USB options at the time. Now with USB-C many of those advantages have disappeared and having USB-C would make it a standard connector. They’re not going to do that because Apple makes money changing people for the “Made for iPhone” brand though I don’t see why they couldn’t continue to do so with USB-C but it’d obviously not be as well controlled. 

One of the other issues that going to USB-C could have solved would have been one of the first USB-C accessories: the wired headphones for the iPhone 7. Tied with the USB-C only MacBookPro you’d have the first connector that works out of the box. This would be a synergy between the Mac and the iPhone that Apple is supposed to be the go to platform on.

Of course it’d take “courage” to shy away from the “Made for iPhone” profit. Maybe Apple has some more spare?

No comments

Tracking my podcast backlog with influxdb and grafana

January 16th, 2017 | Category: analytics

I have a lot of podcasts in my backlog. Over 2000 podcasts remain behind in my history and I’ve got more than enough audio to go on for years. However the problem I had was that I wasn’t sure if I was making any progress on my podcasts or if I was slowly trending backwards (which I had been for years). Before I started at LinkedIn, my commute to work was generally a 15 minute train ride from downtown San Jose straight up North First Street. With the walking time (~10 minutes to/from stations), that landed me with less than 50 minutes of audio time each day. The problem with that was of course the one podcast I was most behind on, Radio National’s Late Night Live, is 50 minutes long and at the time aired five nights a week (now it’s four nights a week, they dropped the Friday night “classic” show which were episodes from their archive). At the time I think I was delayed to around 2009, maybe even as far back to 2007. But I didn’t have the data to see that. Now with a couple of years of LinkedIn, it felt like I was making progress but show me the data!

Read more

No comments

Using Cacti to analyse your inbox

January 09th, 2017 | Category: analytics

For a few years now I’ve had a Cacti instance set up to monitor my inbox. It started ages ago when I realised I had a massive email backlog (over 9000 emails!) and I wanted to track my progress on getting back on track. To do this I turned to a Cacti install I had set up to monitor an Airport Extreme that was my network gateway.

Cacti Email Statistics Graph

Here’s what that looks like for my unread email for the last day. You can see that email slowly creeps up overnight and then around 8am I woke up and read the email. This gives you an interesting insight into when you get email and when it gets read. So let’s get this set up!

Read more

No comments

Alexa versus Siri – you said what?

January 02nd, 2017 | Category: technology,thoughts

For a while now I’ve had an Amazon Echo which is powered by Amazon’s Alexa platform in my living room and for much longer Siri on my phone. Having the two is interesting to see how each of them behave in different situations, which bot understands what I’m saying versus the others. Now while Alexa doesn’t always understand generally it isn’t offensive (usually isn’t offensive anyway [NSFW]), Siri on the other hand will quite happily quip back at me something snarky.

Read more

No comments