[Gmod-help] MySQL Chado Schema

[kevin greer]

Hi Dave,

Thanks for the reply. I definitely understand why PostgreSQL was chosen, 
I would not have considered using MySQL before version 5. Currently all 
of our systems use MySQL and I think that using PostgreSQL would be a 
pretty tough sell. I did find that BeetleBase uses Chado with MySQL.

Thanks,
   Kevin

Dave Clements, GMOD Help Desk wrote:
> Hi Kevin,
>
> MySQL is not officially supported by GMOD for Chado.  Chado takes 
> advantage of many DBMS features, such as foreign keys and other 
> integrity constraints, that were not available in MySQL when Chado was 
> created.  We strongly encourage people to use PostgreSQL.
>
> If you use MySQL you will have to do some porting of both the schema 
> definition (the DDL), and of the the tools that use Chado.  You also 
> still may not be able to get the same level of data constraints in 
> MySQL as you can with Postgres.  I believe there are a few sites out 
> there that run Chado on MySQL, but I don't know who they are.
>
> I will:
> 1. Fix the website to more clearly state the above.
> 2. See if I can find out who, if anyone, runs Chado on MySQL.  I'll 
> add that list of users to the web site.  I'll also let you know what I 
> find out.
> 3. Post this email to the Gmod-schema mailing list.  That list 
> discusses all things Chado.  I recommend subscribing to it if you 
> haven't already done so.
>
> Is MySQL a requirement for your shop?
>
> Thanks,
>
> Dave C.
> GMOD Help Desk
>
>
> On Jan 15, 2008 4:59 PM, kevin greer <kevin at agcol.arizona.edu 
> <mailto:kevin at agcol.arizona.edu>> wrote:
>
>     Hello,
>
>     Is there a MySQL version of the Chado schema available.  Do you
>     know of
>     any issues with deploying the Chado database in using MySQL?
>
>     Thanks,
>       Kevin
>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://brie4.cshl.edu/pipermail/gmod-help/attachments/20080116/562f8d9e/attachment.html>