Fast Running Blog
November 26, 2024, 10:07:39 am *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: SMF - Just Installed!
 
   Home   Help Search Calendar Login Register FAST RUNNING BLOG  
Pages: [1]
  Print  
Author Topic: Query my running database  (Read 3648 times)
Paul Petersen
Cyber Boltun
*****
Posts: 891



WWW
« on: October 03, 2007, 03:45:50 pm »

Something that could help make this site great would be to leverage the power of the back-end database. I'm not saying I want to write my own SQL statements or anything (although that would be nice), but a query wizard would be most beneficial. Once again, the RunningAhead.com online log provides a most excellent example.

http://www.runningahead.com/logs/3bd304da39294ede840f576dd54b3c53/search

Queries like these would be even more powerful if the Blog had a few extra inputs for each day:

1. Input for time of day for run (including option to separate out multiple runs for a day for those of us who like to do doubles and triples).
2. Input for weather conditions and temperature.
3. Drop-down list for course name, with option to add or delete courses (doesn't need to tie to course tool or anything).
4. Drop-down list for shoe name, with option to add or delete shoes (see previous post on shoes)
5. Input for duration of run.
6. Pace can be automatically calculated from distance and time, and stored in another field

I think storing a lot of this info, especially time, pace, and course name, would be beneficial. For one thing, it would cause each blogger to pay even more attention during the run, and once the data are stored, they are there forever, and can be sorted and compared through the query wizard. For example, I could query [DISTANCE] > 11 AND [DISTANCE] < 17 AND [PACE] < 6:30 AND TEMPERATURE > 70 in order to identify and sort through faster-paced medium-long runs run in the heat. The possibilities are endless.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.2 | SMF © 2006-2007, Simple Machines LLC Valid XHTML 1.0! Valid CSS!