[Gmod-help] MySQL Chado Schema

[Dave Clements, GMOD Help Desk]

Hi Kevin,

I agree that MySQL 5 is much more feature rich that its predecessors.
However, porting will still require translation.  Thanks for the pointer on
BeetleBase.

And, I did not post my previous e-mail to GMOD-Schema as I meant to, so you
will get a second, nearly identical copy of my previous e-mail shortly.  I
apologize for that.

Dave C.
GMOD Help Desk


On Jan 16, 2008 10:50 AM, kevin greer <kevin at agcol.arizona.edu> wrote:

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