Large sites

• Gravityspot

  

  Full-featured social networking site including user-uploaded embedded video, photo galleries, personal messaging, forums, calendar, and travel guide. Written in Ruby on Rails and uses MySQL, ffmpeg, flvtool, the ImageMagick suite, and other tools.

  I implemented the site based on mock-ups from the designer. Free account required, or log in as "demo" with password "password". Project was through Tensegrity Development and went live June 2008.

• Chicago Archive of Indigenous Literatures of Latin America

  

  A database of indigenous literature, with advanced and multi-faceted search capabilities. I was involved in the database design and conceptualization of the scope of the project, and then went on to implement the site in Perl using MySQL. Project went live June 2007.

• Dioptrice Telescopes Database

  

  A database site designed and developed for the Adler Planetarium & Astronomy Museum, Chicago, to catalog refracting telescopes constructed prior to 1775. I was involved in the database design process and developed the site using Perl, MySQL and standards-compliant HTML/CSS, as well as the graphic design. Database includes dynamically updated graphs and advanced search features. Data entry is done through a password-protected portion of the site. Project went live March 2007.

Small sites

• Open Produce

  

  I did the design, image sourcing, and coding for this produce store's website (I also co-founded the company). It is a simple web presence that tells customers about the store and provides contact information. Has integrated Google Maps widget for people to get driving or transit directions to the store. Written in PHP. Project went live July 2008.

• Quote Wall

  

  This is a Facebook Application (Facebook account is required; click here, for a screenshot) which allows users to quote their friends. Developed in Ruby on Rails with one other developer, it makes use of the Facebook API to query for user data and FBML for integrated output. Project went live February 2008.

• Websters Signatures Database

  

  Another job for the Adler, I converted a 15,000-entry static table into a searchable database, with an interface for the public to suggest corrections. Very simple design at the request of the client. Written in Perl. Project went live March 2007.

• Weathorr

  

  A personal project to aggregate weather sources and data onto one site. Pulls data from the National Weather Service, the University of Wisconsin, the Canadian Meteorological Center, and other sources, and displays current data and forecasts in a semi-customizable format for Chicago, San Francisco, and Boston, and other cities. Project went live July 2005, and source code is available (Perl).

Modifications and updates

• TeVCat Gamma Ray Source Catalog

  

  This project of the Kavli Institute for Cosmological Physics at the University of Chicago was already off the ground when I was brought in as a consultant to migrate the catalog from a proprietary, home-grown flat-file format into a relational MySQL database to increase performance, reliability, and scalability. I also fixed many outstanding bugs in Perl, javascript, CSS, and many layout issues, and wrote a password-protected interface for managing the data in the catalog. Project went live July 2007.

Non-web programming projects

• Pcapdiff

  

  Working as a volunteer technologist for the Electronic Frontier Foundation, a non-profit digital civil liberties group, I helped write Pcapdiff, an open-source tool written in Python developed as part of a network neutrality testing project. It makes use of libpcap and is aware of TCP Checksum Offloading, 802.1Q VLANs, and other quirks of the modern Internet. Pcapdiff was released in November 2007, and source code is available.

• Switzerland

  

  Switzerland is a much more sophisticated successor to the pcapdiff software that I was also helped write. Switzerland is an open source software tool for testing the integrity of data communications over networks, ISPs and firewalls. It will spot IP packets which are forged or modified between clients, inform you, and give you copies of the modified packets. Switzerland was released in July 2007 and source code is available (Python and C).