Changes between Initial Version and Version 1 of Database_Development


Ignore:
Timestamp:
Nov 8, 2013, 10:17:53 AM (6 years ago)
Author:
hazen
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • Database_Development

    v1 v1  
     1This page is for notes related to the development/update of the EDF
     2administrative database.  The current system is workable, but suffers
     3from many defects.  My preference is to develop and test a new system
     4which is similar enough in the underlying schema that the existing
     5data can be migrated to the new system.
     6
     7Here are my thoughts on what is needed to update the current system:
     8
     9* Provide more useful output to front office
     10 * Spreadsheets, etc for dept use
     11 * Upload files for UIS if possible
     12 * Reports for Rachel (spreadsheets)
     13 * Usable interface for guest users (Rachel)
     14* New UI with uniform look/feel, uniform underlying technology (no mix of languages, etc).
     15 * Uniform interface for editing a list of items with underlying detail records
     16  * Search/filter terms remembered for session
     17  * Paging/scrolling of large result sets
     18  * Sort ascending/descending by column
     19 * Unified library of standard form gadgets, i.e.:
     20  * Pull-down list of projects with filter applied
     21  * Pull-downs for date selection (year, yyyy-mm, sundays, etc)
     22* Better authentication (Authen::PAM or something like it)
     23* use SQL transactions
     24* General thoughts on technology
     25 * mySQL strongly preferred
     26 * Prefer Perl/DBI with CGI::Session or similar
     27
     28