Fwd: [Gmod-help] MySQL Chado Schema

[Dave Clements, GMOD Help Desk]

Hello all,

I keep forgetting to CC my e-mails to help.

Dave C.

---------- Forwarded message ----------
From: Dave Clements, GMOD Help Desk <gmodhelp at googlemail.com>
Date: Jan 16, 2008 10:39 AM
Subject: Re: [Gmod-help] MySQL Chado Schema
To: kevin greer <kevin at agcol.arizona.edu>


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> 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/8e31d79f/attachment.html>