Which mysql for a new project?

Rails
1

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

2

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.

3

In databases.yml, it ‘recommends’ v4.1 or 5.0.
I have only today upgraded to 5.0, and all seems well so far…

4

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

5

Really, the decision is strictly based on whose code you want to debug
– yours, Ruby, Rails, MySql, web server or operating system. :slight_smile:

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
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails

–
M. Edward (Ed) Borasky

6

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.
:slight_smile:

Well … I understand Fedora 5 is almost ready for beta testing. gcc 4
is your friend. :slight_smile:

Eric K. wrote:

On 12/9/05, M. Edward (Ed) Borasky [email protected] wrote:

Rails mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails

–
M. Edward (Ed) Borasky