People in the business often refer to this as the "LAMP" programming enviroment, because the standard toolset consists of Linux, Apache, MySQL and PHP (or Perl).

I usually maintain a 9-5 job and freelance at night, but sometime in the future I can forsee combining these efforts into a single business. More on that later.

Some of the things I've been involved with:

University of Arizona Off Campus Housing Online

This project is a fully automated housing listing and roommate matching website built from scratch for the University of Arizona's Department Of Off-Campus Housing.

This particular project has proven enormously successful. As of late 2005 the system had run something along the lines of 1500 ads and was one of the highest trafficked sites on their server.

Technologies: PHP 4, MySQL, with some Java helper apps, deployed on OS X.

University of Arizona: Leadership and Involvement Transcript database

This project is another ground-up project I built for the University of Arizona. This acts as an online counterpart to the L.I.T., which is a program that tracks a students learning outside the classroom throughout their undergraduate careers.

I built the database and website where students log their participation as well as the backend where advisors track and reward student progress.

The L.I.T. is a really neat program in its own right, and my database moved the whole process online. There are currently a few thousand students using the L.I.T. system.

Technologies: PHP 4, MySQL, deployed on OS X.

stolenbicycleregistry.com and stolenguitarregistry.com

These are both nonprofit efforts I began to help combat bicycle and guitar theft. Rather than having a lot of smaller fiefdoms maintaining their own lists (colleges, individual police forces, etc) I wanted to see what would happen if such stolen-goods databases were opened up to the public, with some neat searching and querying technolgies added into the mix. The result has been very successful.

Technologies: PHP 5, MySQL, deployed on FreeBSD

stolenmotorcycleregistry.com

As a byproduct of the popularity of stolenbicycleregistry.com, I had hundreds of motorcycle theft victims contacting me about registering their stolen motorcycles. They were driving me nuts. :)

Thus: stolenmotorcycleregistry.com

More and more people want me to recycle this site and searching technology. I'm pretty happy with it so far.

Technologies: PHP 4, MySQL, deployed on Linux

www.puerto-penasco.com

This site - one of my most popular - was converted from a printed publication I inherited from a former client. The aesthetics could use a lot of work, but right now the content is the single best source of information for Puerto Penasco / Rocky Point Mexico, and the site gets quite a bit of traffic. Rocky Point itself is gaining popularity, and consequently the site has seen an enormous amount of growth in the last few years.

Technologies: PHP 4, MySQL, custom shell scripts, deployed on RedHat Fedora on my own equipment

Simple WebBug (not yet deployed)

One of the small 'helper' applications I have written is a system for creating and tracking Web Bugs, aka Web Beacons, for use in promotional HTML emails.

Simple WebBug lets you get a rudimentary count for how many people have 'opened' an HTML email you have sent out. The use and existence of Web Bugs are somewhat controversial, but as with most technologies they have a legitimate use, but it's a few abusers that have given them a bad name.

Simple WebBug is on the back burner while I wrap up other more pressing projects.

Technologies: PHP 4, MySQL

ShareMyWiFi.com

A site for listing and sharing WiFi access points with your neighbors. I started this right around the time Google Maps was becoming a big thing, so I switched gears and retrofitted it to work with the Google Maps API. I released this on a Monday, Digg.com hit it on Tuesday, and by Wednesday I had 300 listings. Thus: a) the Google Maps API is cool, and b) there's a lot of people out there who don't mind shring their WiFi.

Technologies: PHP 4, MySQL, Google Maps API