Projects: MySQL

A relational database management system

Valero Texas Open

The Valero Texas Open is one of the oldest tournaments on the PGA Tour. Following the 2012 tournament, I created an image gallery to show off pictures from the tour and associated events. The easiest way for the client to upload and manage their media was to employ a separate Flickr account. There, they organized and tagged their images as they saw fit. All media was later pulled into the site via cron job requests to the Flickr API. Once published, the imagery would automatically be grouped into the proper album.

Wedding Site

The site I designed for my wedding featured a simple photo gallery and a Google maps interface that gave quick driving directions between draggable start and end points. All wedding locations were overlaid. Users could easily zoom to these locations by touching upon the icons in the top legend.

Task Manager

The task manager is primarily driven by PHP. It makes calls to a purpose-built, normalized MySQL back-end. Following a secure login an individual user may easily submit, track, edit, archive, and delete tasks organized by project and priority. Administrators may assign access privileges to both users and projects. I use this tool daily to keep myself organized, so it is under constant development. New features under development include a search bar, optional due dates, and email reminders if an unfinished task is overdue.

Adapt Training

Adapt Training is a fitness facility dedicated to using the latest advances in training and physical therapy. Their computer programming needs were twofold: 1) an objective method of scoring exercise movements using a rubric designed by the head trainer for the purpose of assigning workouts, and 2) a method to share with the client (with username and password via a large database) their custom workout. These tasks had to be wrapped into an accessible, easy-to-use interface. I used MySQL, Perl (CGI), and JavaScript to implement a form-based approach via web-browser.