PHP and PostgreSQL Open Sesame

by David Sklar

Related link: http://wwwac.org/main.html#ossig



At a meeting last night of the WWWAC Open Source SIG, Tom Clarke of Union Square Internet Development gave a talk on how his company moved Sesame Workshop from a proprietary platform to an open one.


The motivation for using Open Source products came from within Sesame Workshop and it was not ideological -- it was financial. The ongoing costs of licensing and maintenance for StoryServer, Oracle, and their Sun hardware was too much to bear, especially with a decreased IT staff.


In 4 or 5 months, Sesame Workshop's sites were rebuilt using PHP and PostgreSQL, running under Apache and Linux on Intel-based hardware. The new sites also use add-ons popular in the PHP community: PHP Accelerator for caching compiled scripts, JPCache for caching generated pages, and ADOdb for database access and query caching.


The success of this project is a reminder that ideology aside, sometimes Open Source is just better for the bottom line.