MySQL

Implemented a database-rule-driven product configurator, as part of a migration of the Rig-A-Lite site to Drupal 7. Rig-A-Lite provides lighting solutions for hazardous environments, such as light fixtures for off-shore oil rigs. Their old product configurator did not enforce legal configuration choices - such as which ballasts require fuse blocks, or are not available with metal halide lamps, for example - which caused order processing aggravation for their worldwide sales reps and customers.

The configurator is iframe'd into Drupal, leveraging the company's old sophisticated full-custom PHP/MySQL/JQuery CMS backend to populate its new Drupal front end. The new rules data is edited in a valid-configurations Excel table, and imported into the CMS, to drive the product configurator user interface.

As of this writing, the new site is still under development.

Triaxle is a puzzle game based on hexagonal instead of square neighbors. Score history is tracked both locally and versus other users, via a server database.

This was the first complex program I wrote in ActionScript 2 - complete with soundtrack, fairy lights, gameplay, PHP backend - big learning experience.

Now with direct access to the Triaxle Scoreboard.

CrossPlan / Cross-Suite is a site for social integrated circuit block-level layout editing. I built database, intelligent integrated circuit editor, design history management, integrated instant messaging, and the whole Drupal site, for The Shearwater Group and Pinebush Technologies. This site is not public - please contact me if you need a demo. Alpha release only - the recession put this project on hold.

FlexSimpleStats tracks semantic usage statistics within my simulators - what users actually do with them. These days, one can use Google Analytics for this, but SimpleStats predates GA by years. The server side of SimpleStats is implemented in PHP and MySQL, called by client-side Java, Flash, or Flex. This tool browses and charts CourseWare historical usage data, back to January, 2004. Originally implemented in Flash, now in Flex.