Hi Kevin,<br><br>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.<br><br>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.
<br><br>Dave C.<br>GMOD Help Desk<br><br><br><div class="gmail_quote">On Jan 16, 2008 10:50 AM, kevin greer <<a 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;">
<div 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><font color="#888888">
Kevin</font><div><div></div><div class="Wj3C7c"><br>
<br>
Dave Clements, GMOD Help Desk wrote:
<blockquote 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 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>
</blockquote>
<br>
</div></div></div>
</blockquote></div><br>