Database

Simple Delimited

Originally, Depo output the important crystallographic information extracted from the CIF file into a simple semicolon delimited text file and a custom search program was to be written. However, as the text file can be read into database packages such as MS access and lotus approach or into spreadsheet packages such as MS excel or Lotus 123 and search capability being accomplished from within these programs it was seen as not a priority.

php and MySQL

With recent updates to the x-ray webserver a new method of access to the Depo database was developed using MySQL and php custom database scripts.

With little modification to the data in the Depo database it could be loaded into a custom MySQL database this allowed manipulation of the database either via a php webpage or directly via an authorized mySQL user.

A reduced capability trial version of the search engine and database interface are also available via the database link on the webpage.