Archive for February, 2013

Reunion Tour

February 5th, 2013 No comments

This week, the three of us that made up a rock group when we were in high school are reuniting. 15 years later, we’ve all ended back up in the same area we grew up and are going to get together and play through some covers. I have to say I’m pretty pumped.

I’ve been spending time since Christmas on the website’s Edge area. Edge members can watch live lessons, archives of recorded lessons, and interact with the instructors and (maybe more importantly) other Drumeo members via forums, Youtube and e-mail. It’s a pretty incredible concept, and one I’m glad I can participate in. I’ve been able to get some exercises to bring my drumming chops back up to what they once were, and hopefully push them beyond. Back then, my drums stayed at the bassist’s house (and I was too poor for a second set), so practice time was limited. I intend to change that this time around and be more deliberate about practicing and improving my skill set.

If you’re looking for a great drumming community, check out!

Categories: Drums and Drumming Tags: , ,

Time conversion gymnastics in Python

February 5th, 2013 No comments

I was recently working with a sqlite3 database using the DATETIME(‘now’) SQL construct to save the time a row was updated. This results in a format of e.g. 2013-02-05 17:50:42, which is in UTC. In order to display this in local time, I did the following gymnastics:

import calendar,time
time.strftime("%Y-%m-%d %H:%M:%S", time.localtime(calendar.timegm(time.strptime(thetimefromdb, "%Y-%m-%d %H:%M:%S"))))

Is there a better way?