Web interface rewritten
Rewriting of the web interface for the collections' database has almost finished for now. This was necessary to meet the latest standards approved by the WWW Consortium, such as XHTML 1.0 and CSS2. Several changes were made into the scripts, required by the movement to PHP 4.2.3.
Also, authentication mechanism was added for web users, so that multiple levels of access control can be utilised. Hopefully, the general look of the page was also improved.
Collections database moved to MySQL server
In July 2002, the collections management database which previously worked on
MS Access was reorganised.
The new system implements client-server architecture: the data is now being hold in MySQL, a popular open-source SQL server. Although MySQL has yet no support for foreign key constraint and few other useful features, its speed, reliability, simplicity, good documentation and cost of ownership makes it a well-founded choice. The user interface utilised for in-house data entry and reporting still grounds on MS Access 97 and ODBC connection.
This this step resulted in notably increased performance for using in multi-user networked environment. Also, this made it possible to provide always up-to-date information on the web.