Here's a web application for you.
The government of country A is cash strapped and needs a learning content management system and testing system for it's public schools, military, hospitals and universities. The government wants to allow all citizens to be able to check out learning materials (SCO's=shareable content objects) that can have test/progress results stored in a database that gov. ministers can see the "progress" of learning in the kingdom. New knowledge material can be updated dynamically across several sites. As soon as something new is viable enough for creating a class or learning session over the web, a learning object is created.
Several institutions must have a local server available for their use since the internet is not so reliable in country A. The system must have some safegaurds against cheating and fraud.
What is the best way to store a student's progress in the system across courses, years, sites and institutions?
Country A has several college students who can program but cannot afford expensive programmers, or Microsoft products, and cannot spend money buying solutions. Country A's people want the pride of having their own learning system that is standards complaint with various international learning standards and groups (RDF,AICC/SCORM/ADL). Moreover, they want their school's curricula and libraries accessible over the web by handicapped persons (section 508).
They want an opensource solution. Maybe a database such as Firebird, post-gre, mysql or even Oracle/MS Sql since each institution has their own database system. They want the datatypes to be stable across the application. They want an installer package that can set up a webserver/database server that can then download current courses/records to a central distributed repository on demand (DB to DB transfers, XML transfers, etc.)
What would you go with?
Would you use Java, Jython, PHP, Python, Perl, Pike or a more developed Content system like Plone/Zope that may require programming for the AICC/SCORM code base, etc.
I think with LAMP. PHP might win.