Web application generation

Also know as MVC (model view controller) or CRUD (CReate Update Delete) applications.

Open source

None known other than SeedPod, though you could use something like PhpMyAdmin. SeedPod is different in that it is model-driven and has the expectation that single model may be tweaked and used to build several similar but not identical systems.

Commercial products

We may want to evaluate these. Not sure how well they handle complex schemas.

Qrimp - $99 developer edition, $1999 Enterprise, $4999 Royalty Free Distributable http://www.qrimp.com/serverlicensing.html

DBQwikSite - free personal edition; $180 for "unlimted pages" http://www.dbqwiksite.com/comparison.asp

Alpha Five - $399 developer plus $699 for Web App Server http://en.wikipedia.org/wiki/Alpha_Five

dQuery - $795 http://www.dquery.com/newsite/detailed_features.html http://www.pcmag.com/article2/0,2704,1883602,00.asp

AwareIM - $999 for 10 user version http://www.awareim.com/portfolio.html

Desktop

These probably do not meet our extendability needs

• Microsoft Access
• Filemaker Pro
• Kexi (multiuser open source Access clone - http://www.kexi.pl/en/Start )

Online Only

These probably do not meet our data privacy needs, but they are a good source of ideas:

• http://quickbase.intuit.com/
• http://dabbledb.com/

Frameworks

There are many many programming frameworks that all claim to help you build "quick" or "rich" web applications if you learn their API.

Perhaps the current favorite is Ruby on Rails. See "Skip the CRUD: Building a Simple Database Backed Web Application Using Ruby on Rails"

UW Catalyst developed one called Solstice. It is written in perl and leverages campus knowledge.