F.A.Q.
Frequently asked questions regarding the Central Manchester CLC helpdesk issue management system. This will grow in size with the receipt of frequently asked questions.
Is there a MySQL migration planned?
The helpdesk issue system currently uses views in order to simplify a great deal of embedded SQL and to speed up the design and execution of those pages. MySQL has no plans to implement relational views until at least version 6 and so migration to MySQL is not on our immediate "to-do" list. It is not impossible, far from it. To migrate it would take some small PHP changes (the code is designed to be easy to migrate to other high end databases that implement views) and some larger SQL changes. Most of the embedded SQL relies in some way on using a view and so it would be an extensive job (but not a particularly difficult one) to make it usable with MySQL.
We would strongly recommend installing PostgreSQL, both from a development point of view and from a performance point of view, and of course you can always have both database servers running simultaneously.
