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.