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

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

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: