OIO is a Web-based metadata/data management front-end which is built using Zope and works with Postgresql. No programming is required to build and manage Web-forms or to perform data mining/analysis on the collected data. It is in production at the Harbor/UCLA Medical Center for clinical outcomes management and research data. Forms created with OIO and hosted on any OIO server can be downloaded as XML files. Once downloaded from the "Forms library" and imported into an OIO server, the necessary database tables are automatically recreated and the imported forms become immediately available to the users of that OIO server.
Formulator is a flexible, extensible framework for the creation and validation of web forms in Zope. Web forms can be created with a web-based management interface. When a form is submitted, many common validations, such as testing for required fields or certain types of input, can be automated.
Archetypes is a framework for developing new content types in Plone. The power of Archetypes is first in automatically generating forms, second in providing a library of stock field types, form widgets, and field validators, third in easily integrating custom fields, widgets, and validators, and fourth in automating transformations of rich content.
Keylime for Zope is a set of generic objects to facilitate fast SQL application development. It offers the following objects, which can be used or overridden: htmlView, htmlInsert, formInsert, formUpdate, and htmlDelete. It uses Folder properties to define sqlTable, sqlKey, and sqlUniq so that the application will function using generic or overridden forms. Infinitely hierarchical SQL applications can be written very quickly. Sample apps and a Zope installation guide are included.