# Which mysql for a new project? **URL:** \ **Category:** Rails\ **Created:** [December 9, 2005, 4:12pm UTC](https://www.ruby-forum.com/t/which-mysql-for-a-new-project/49876 "2005-12-09T16:12:33Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![eknapp](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/ecd19e/32.png) [@eknapp](https://www.ruby-forum.com/u/eknapp)\ **Post date:** [December 9, 2005, 4:12pm UTC](https://www.ruby-forum.com/t/which-mysql-for-a-new-project/49876/1 "2005-12-09T16:12:33Z")
Hi all, I am about to start a new RoR project. Which version of mysql is the current best one to use? I will be using the soon-to-be-released RoR 1.0 for the project. I really don’t want to start a PostreSQL vs. MySQL vs. Whatever war. I have all databases including Oracle at my disposal. This project will be my testbed for using RoR with mysql. I will be doing other tests with other dbs later. Thanks for any input! -Eric ---
**Author:** ![eknapp](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/ecd19e/32.png) [@eknapp](https://www.ruby-forum.com/u/eknapp)\ **Post date:** [December 9, 2005, 5:46pm UTC](https://www.ruby-forum.com/t/which-mysql-for-a-new-project/49876/2 "2005-12-09T17:46:35Z")
If you can wait about a week, it looks like MySQL 5.0.17 will be released about then. This version will fix many nasty bugs. RoR officially recommends either version 4.1 or 5.0, but version 4.1 is no longer being actively developed by MySQL in favor of the 5.0 version. ---
**Author:** ![eknapp](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/ecd19e/32.png) [@eknapp](https://www.ruby-forum.com/u/eknapp)\ **Post date:** [December 9, 2005, 9:41pm UTC](https://www.ruby-forum.com/t/which-mysql-for-a-new-project/49876/3 "2005-12-09T21:41:05Z")
In databases.yml, it ‘recommends’ v4.1 or 5.0. I have only today upgraded to 5.0, and all seems well so far… ---
**Author:** ![eknapp](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/ecd19e/32.png) [@eknapp](https://www.ruby-forum.com/u/eknapp)\ **Post date:** [December 10, 2005, 4:04am UTC](https://www.ruby-forum.com/t/which-mysql-for-a-new-project/49876/4 "2005-12-10T04:04:53Z")
At this point the first trial box looks like it will be fedora 4. We have not fully decided on the http server. I like lighttpd and we might start with that. I’m a programming teacher at a college and I’m doing this with a group of students. We are going to wait for RoR 1.0 anyway so we might go with mysql 5 and live on the edge! Thanks for everyones input. -Eric ---
**Author:** ![eknapp](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/ecd19e/32.png) [@eknapp](https://www.ruby-forum.com/u/eknapp)\ **Post date:** [December 10, 2005, 2:06am UTC](https://www.ruby-forum.com/t/which-mysql-for-a-new-project/49876/5 "2005-12-10T02:06:37Z")
Really, the decision is strictly based on whose code you want to debug – yours, Ruby, Rails, MySql, web server or operating system. 🙂 In short, do a project plan, “agile-style”. My recommendation is to use as much “old reliable stable stuff” as possible. Save the testing/development/bleeding edge for your _own_ code. So … what OS are you on? What web server will you be using? MySql is a given, so which version of MySql is solid, stable and reliable on your OS/web server? Eric K. wrote: > -Eric > > * * * > > Rails mailing list > removed\_email\_address@domain.invalid > [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails) – M. Edward (Ed) Borasky > **[世界杯竞猜彩票-世界杯官网竞猜（集团）有限公司](http://www.linuxcapacityplanning.com/)** > > 世界杯竞猜彩票一直以来遵守商业道德，世界杯官网竞猜坚持诚信为本，保证诚实经营。世界杯竞猜彩票先后成为安徽省电子商务协会理事单位、安徽省网商协会会员单位、合肥市电子商务协会理事单位、合肥市服务外包行业协会会员单位、安徽省云计算产业促进会会员单位。世界杯官网竞猜一直保持良好的技术及服务态度，更好地为客户服务。 ---
**Author:** ![eknapp](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/e/ecd19e/32.png) [@eknapp](https://www.ruby-forum.com/u/eknapp)\ **Post date:** [December 10, 2005, 5:06am UTC](https://www.ruby-forum.com/t/which-mysql-for-a-new-project/49876/6 "2005-12-10T05:06:14Z")
Hmmm … teaching them bad habits, eh? Or teaching them skills that will serve them well in the real world – how to debug other peoples’ code. 🙂 Well … I understand Fedora 5 is almost ready for beta testing. gcc 4 is your friend. 🙂 Eric K. wrote: > On 12/9/05, M. Edward (Ed) Borasky [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > > > > > * * * > > Rails mailing list > removed\_email\_address@domain.invalid > [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails) – M. Edward (Ed) Borasky > **[世界杯竞猜彩票-世界杯官网竞猜（集团）有限公司](http://www.linuxcapacityplanning.com/)** > > 世界杯竞猜彩票一直以来遵守商业道德，世界杯官网竞猜坚持诚信为本，保证诚实经营。世界杯竞猜彩票先后成为安徽省电子商务协会理事单位、安徽省网商协会会员单位、合肥市电子商务协会理事单位、合肥市服务外包行业协会会员单位、安徽省云计算产业促进会会员单位。世界杯官网竞猜一直保持良好的技术及服务态度，更好地为客户服务。