Database Information
The standard database used at IGSP for projects is MySQL. We also have an Oracle 10g database installation, though this is reserved for applications that require Oracle. Oracle's licensing severely restricts access to the database and also web-mediated access to data stored in the Oracle database.
MySQL
IGSP has multiple installations of MySQL, differentiated in the main by the status of development.
"Development" installations are generally isolated from the core IGSP server infrastructure, and the databases are much more accessible to individual users. As their name implies, the databases in this category are "under development" and are generally not made broadly available.
"Production" installations are reserved for mature products that have arrived at a stable schema. The production installations are maintained and backed up by IGSP staff and the databases are part of the core IGSP server infrastructure.
If you want to develop a MySQL database, please contact IGSP IT, and a MySQL database will be set up for you. The basic Linux workstations include the client software and programming libraries for MySQL development.
IGSP runs MySQL 4.1.x on the production servers.
Oracle
IGSP maintains an Oracle 10g database server for applications that explicitly require access to an Oracle backend. Because Oracle's licensing model is quite restrictive, we highly recommend you consider MySQL for developing new applications. If you have a specific need for an Oracle database, please contact IGSP IT (Email) for further information.