Here's a new site for Family Resources of Western Pennsylvania, built on the latest version of the Actual Size CMS. We did a full restructuring of our admin interface, and there's a lot of gorgeous work on the front end from the Actual Size team. My role was to design the data structure (MySQL) and do the dynamic server-side scripting (PHP MVC Codeigniter), coordinating closely with our designers and front-end developer. Significant challenge: integrating (successfully!) two different flavors of PayPal clearing for donations and benefit purchases.
Another new site, for hockey blog TrueHockey. The excellent, bold design was done, of course, by our fine team at Actual Size Creative. Notable problem solved: there are a lot of different types of content, many of which behave slightly differently, but all need to be aggregated in some places, and performance needs to be responsive. I structured the database with this in mind, doing a combination of discrete tables for presentation and aggregated tables for searching. Another interesting problem was commenter authorization, so the site offers login through a native system, Facebook, and Twitter, each of which are, of course, rather different, but the behavior is consistent for users from each. I coded the CMS and dynamic front-end in PHP MVC framework Codeigniter.