Ask the Expert

Choosing between MySQL 4.0 and MySQL 5.0 for client server app development

In our company, we are plan to develop a client server application using PHP and MySQL. We are planning to use either MySQL4 or MySQL5. Which is better preferable? Is MySQL5 more stable?

    Requires Free Membership to View

    Login

Your choice will depend on what you need from your MySQL server. At a bare minimum, you should be using the latest release of MySQL 4.1. From there we need to look at your needs. Do you need Stored Procedures? Views? Triggers?

The full list of what MySQL 5.0 adds is available here. The tradeoff is that ,while MySQL 5.0 is declared production-ready, it is less proven than MySQL 4.1.

For a shop that is in the planning stage or development stage of a project, I would recommend being more agressive with the version of MySQL used because as you develop and mature your product, the version of MySQL you have chosen will also mature. As such, you may even want to look at the feature list of MySQL 5.1 and see if there are features you can take advantage of.

This was first published in April 2006

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.
    Back to top