MySQL

ArchaeoSim 4 is an HTML5 re-implementation of the original ArchaeoSim I implemented as a CourseWare Java applet a decade earlier for Harvey Weiss at Yale University.

ArchaeoSim explores social and environmental tradeoffs in the ancient farming civilization of ancient Subir (northern Mesopotamia). This is an individual-based simulator, with the settlements acting as the individuals. Students explore assumptions by setting parameters. The actual civilization was devastated by climate change in pre-history. This new version of ArchaeoSim uses a satellite image for the landscape map, and the latest archaeological evidence of settlement sizes and rainfall patterns.

ArchaeoSim 4 debuted for course use at Yale University in November 2014.

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.

Last I knew, most products hadn't been converted to use the new configurator. That was a design feature, that the new system would allow them to use both old and new product configurators side by side, as they gradually converted products.

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 was 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. The recession put the project on terminal 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.