bgruening

First class postgresql/mysql Galaxy integration

With this document I try to struture my ideas about a solid postgresql/mysql integration in Galaxy as part of out GIE work and beyond.

A lot of tools relying on ORDBMS for storing and quering data. This is not so common in NGS or proteomics but it is in cheminformatics, text-minining and genome annotation. See for example blast2GO which uses a mysql database as backend, or the ChemicalToolBox for storing the entire PubChem in a phchem indexed postgresql backend. In general I think it makes sense to support ORDBMS in Galaxy if data do not change