Managing Online Lists and Quickly achieve it
The basic requirement is always the same:
- a sortable list of items, with some columns
- some categories and sub-categories
- search, tags, display by creation/modification date (latest/newest, oldest)
- some views: browse, details, results of search (save searches which permits to provide individual views)
Some more requirements com rapidly:
- anonymized export of the database
- easily display database model
- add new fields and take it into account automatically in all default views
- authentified addition / modification / deletion (ACL ?)
- manage spam / (automatic) verification of entries
- versioning
- batch addition to quickly import new data
- filtering displayed data (include / exclude) for easy navigation, data drilling
- display tags and tagcloud
Some tools pretend to achieve it really rapidly, but I never spent suficient time to industrialize it for quick deployment
- CakePHP
- Smarty
- using PostgreSQL and PhpPgAdmin (gives too much rights to the user and the interface cannot be simplified)
- symphony / python
Some examples
- http://asso.lanpower.free.fr/index.php?option=com_content&view=article&id=149&Itemid=87 table to be converted
- browse a complex database model with views / categories
- http://linuxfr.org/users/jems/journaux/des-galeries-photo-et-vid%C3%A9o-et-avec-des-tags
- cakephp to be avoided ?
Existing tools / requests about it
- AutoDia see HowToDia
- check if PmWiki would have an add-in (or any other CMS, not drupal :p)
- https://masterbranch.com/postgresql-smarty-projects
- http://linuxfr.org/forums/programmationweb/posts/recommandations-dun-framework-pour-un-site-scientifique Django, Plone, Rails, Symphony, catalyst,
- https://linuxfr.org/tags/gestion_formulaire/public
- http://linuxfr.org/news/premi%C3%A8re-sortie-publique-de-pyramid_formalchemy python :/
- http://linuxfr.org/forums/g%C3%A9n%C3%A9ralcherche-logiciel/posts/cherche-script-php-de-formulaire-textbox-radiobutton-etc questionnaire
- http://linuxfr.org/forums/g%C3%A9n%C3%A9ralcherche-logiciel/posts/cms-pour-formulaire
- http://sourceforge.net/projects/opendb/
- http://semantic-mediawiki.org/wiki/Help:Format_tableau
