Hello all,<br><br>I keep forgetting to CC my e-mails to help.<br><br>Dave C.<br><br><div class="gmail_quote">---------- Forwarded message ----------<br>From: <b class="gmail_sendername">Dave Clements, GMOD Help Desk</b> <
<a href="mailto:gmodhelp@googlemail.com">gmodhelp@googlemail.com</a>><br>Date: Jan 16, 2008 10:39 AM<br>Subject: Re: [Gmod-help] MySQL Chado Schema<br>To: kevin greer <<a href="mailto:kevin@agcol.arizona.edu">kevin@agcol.arizona.edu
</a>><br><br><br>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><font color="#888888">GMOD Help Desk</font><div><div></div><div class="Wj3C7c"><br><br><br><div class="gmail_quote">On Jan 15, 2008 4:59 PM, kevin greer <<a href="mailto:kevin@agcol.arizona.edu" target="_blank">
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>
</div></div></div><br>