My DNA analysis from Athletigen

Google AdSense

A few months ago, I was talking to a coach at my gym about the wonders of science in relation to fitness. We started talking about how we’ll eventually be able to test our DNA to figure out which diet/nutrition we should follow and the effect that’ll have on sports and general physical activities. So a few weeks later, I read an article in a fitness magazine (I think it was Runner’s World) about some companies offering DNA analysis relating to physical fitness and nutrition.

I purchased a kit from Athletigen and it arrived in about 2-3 days. I even got a call from customs as the package got delayed a day crossing over the US/Canada border. It seemed to be a standard DNA kit, spit into a tube, break the seal to release some more liquid, shake, reseal, box it, and mail it back. I haven’t done a DNA kit before – I have a very good idea of ancestry and my past, so I’m not (as) concerned or interested in those details. I’m more interested in learning how to live/work/play better in the present and if I can gain some genetics insights paired/confirmed along with what I feel/think works best for me, then maybe I can do more or maybe just do/follow/avoid specific things.

Continue reading

Heart-rate comparisons with Fitbit monitor

fitbit-surge
Google AdSense

Recently, I purchased a Fitbit – mostly because I love having a GPS when I run to track distance and pace. One of the other benefits is that it’s bluetooth enabled, so I don’t have to worry about sync’ing the data to my computer like my ancient GPS.

I’ve found the heart rate monitor pretty interesting. Here’s a few snapshots of my weekly exercises.

Continue reading

Large MySQL Database Backup, Restoration, & Offsite Storage at DropBox

On Monday, my website host’s (DreamHost) database server crashed and they restored the previous week’s data for all of the databases hosted on that server. Eventually, they were able to restore the daily backups to disk, which allowed users to restore that day’s backup. However, when I went to restore the daily backup, it was about 16 hours old.

Within those 16 hours, one forum had hundreds of posts, topics, and forum reorganization; another WordPress blog had two dozen of posts; while my personal blog (this site) had no changes. At the time, my backup scheduled was:
Continue reading

How to convert a street address to longitude and latitude (geocoding) via web services (Google)

Several years ago, I wrote a blog entry detailing how to use geocoder.us (and Yahoo!) web services to geocode an address. Since then both web services have changed a little and I found myself needing to update my code to support non-US locations. Below is sample code showing how to use Google’s Geocoding web service to get longitude and latitude values for addresses.
Continue reading