<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Dave,<br>
<br>
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. <br>
<br>
Thanks,<br>
Kevin<br>
<br>
Dave Clements, GMOD Help Desk wrote:
<blockquote
cite="mid:71ee57c70801161039j6cbd135axf6c180fc9209598b@mail.gmail.com"
type="cite">Hi Kevin,<br>
<br>
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.
<br>
<br>
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.
<br>
<br>
I will:<br>
1. Fix the website to more clearly state the above.<br>
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.
<br>
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.<br>
<br>
Is MySQL a requirement for your shop?<br>
<br>
Thanks,
<br>
<br>
Dave C.<br>
GMOD Help Desk<br>
<br>
<br>
<div class="gmail_quote">On Jan 15, 2008 4:59 PM, kevin greer <<a
moz-do-not-send="true" href="mailto:kevin@agcol.arizona.edu">kevin@agcol.arizona.edu</a>>
wrote:<br>
<blockquote class="gmail_quote"
style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Hello,<br>
<br>
Is there a MySQL version of the Chado schema available. Do you know of<br>
any issues with deploying the Chado database in using MySQL?<br>
<br>
Thanks,<br>
<font color="#888888"> Kevin<br>
</font></blockquote>
</div>
<br>
</blockquote>
<br>
</body>
</html>