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.
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!
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?