MySQL 5.0 Now Available for Production Use

MySQL 5.0 is out. It now supports:

  • Stored Procedures and SQL Functions (about time!);
  • Triggers (about time!);
  • Views (about time!);
  • Cursors (about time!);
  • Information Schema — to provide easy access to metadata (I don’t know what this is);
  • XA Distributed Transactions — supports complex transactions across multiple databases in heterogeneous environments (sounds good);
  • SQL Mode — provides server-enforced data integrity for new and existing data (about time!).

However, I wouldn’t switch over any serious Enterprise project to MySQL with Oracle buying InnoDB and all, but if you are already using MySQL, this is good news indeed.

Leave a Reply

Your email address will not be published. If you leave an email, you will be notified when there are replies. The comment form expects plain text. If you need to format your text, you can use HTML tags such <strong> and <em>. For formatting code as HTML automatically, I recommend tohtml.com.