tag:blogger.com,1999:blog-6232819486261696035.post6607258160920656801..comments2023-09-25T09:01:44.323-05:00Comments on Getting Genetics Done: Using MySQL to Store and Organize Results from Genetic AnalysesStephen Turnerhttp://www.blogger.com/profile/06656711316726116187noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-6232819486261696035.post-31546682248915138502011-12-12T10:50:05.258-06:002011-12-12T10:50:05.258-06:00Bhoom - not sure if Will's planning on followi...Bhoom - not sure if Will's planning on following this up or not, but here are some other resources for you. The MySQL documentation is excellent, and they have some documentation about Workbench. you're right, you probably want to edit the SQL script in Workbench (http://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial.html)<br /><br />Also, I looked around and there's a serious dearth of resources for how to intelligently use a relational database to store genetic data. Will and I are writing a book chapter that covers this and we'd be happy to share once it's published, but for now, check out these slides: http://osastatistician.com/Stat6910/Dataman.pdfStephen Turnerhttps://www.blogger.com/profile/06656711316726116187noreply@blogger.comtag:blogger.com,1999:blog-6232819486261696035.post-11254500832338855462011-12-12T10:41:09.938-06:002011-12-12T10:41:09.938-06:00Will, thank you for writing this short tutorial. I...Will, thank you for writing this short tutorial. It's been my starting point for trying out mySQL for genetic database. A lot of things right now seems to be very different from the time you wrote this. And, it took some guesses to match what is shown here with what currently is in mySQL workbench. The GUI seems nicer now, but they still keep that scripting window available. Will there still be any follow up posts after this? I still think it's useful.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6232819486261696035.post-56172314814021512332010-02-14T08:51:51.803-06:002010-02-14T08:51:51.803-06:00I think that the MySQL GUItools are being streamli...I think that the MySQL GUItools are being streamlined into MySQL Workbench.<br /><br />http://wb.mysql.com/<br /><br />Workbench 5.2.15-Beta works pretty well, but you might want to hold off until it's out of beta. I've gotten more than one crash trying it out. But once those kinks have been worked out I think it will be a nice integration.Elinoreply@blogger.com