RSSMySQL 5.0 Ready for Primetime
By Nate Mook | Published October 25, 2005, 2:34 PM
The long-awaited 5.0 release of MySQL has arrived to bring the free open source database up to par with its pricey enterprise rivals. New features include stored procedures, triggers and views, along with support for the ANSI SQL standard to ensure compatibility with other database systems.
Such features were once limited to expensive offerings from Oracle and IBM. Stored procedures enable administrators to embed business logic directly into the database to improve performance. Trigers enforce rules at the database level, while Views secure protected information.
MySQL 5.0 additionally includes a new Instance Manager to assist users in starting and stopping a database, as well as editing configuration files and remotely reading error logs.
"We are quite proud to deliver this new version of MySQL -- as it includes the most-requested features from our users, customers and partners," said Marten Mickos, CEO of MySQL AB. Over 30 companies have pledged their support for the new release, including heavyweights Sun Microsystems, Red Hat and HP.
High-performance versions of MySQL database drivers for Java and Microsoft's .NET platform are bundled with version 5 to ensure true cross-platform support. The production release is available for Linux, Windows, Solaris, Mac OS X, FreeBSD, HP-UX, and a variety of other operating systems.
MySQL 5.0 is pretty impressive. If you're looking for a free alternative to SQL Server then check it out. It is very easy to configure. Make sure to download the Administration portion and the Query Analyzer (especially if your coming from SQL Server) as they will give you a better comparison of the products. Also, databases are called 'Catalogs', just a hint from a newbie to other newbies.
Score: 0
|Not sure if I wanna try 5.0 due to new features in it, but MySQL Forever ^_^
Score: 0
|Pfft. PostgreSQL supported these "enterprise" features quite a while ago.
Score: 0
|Let me know when they have all the integration tools for Visual Studio and Windows - or any other OS/IDE combination.
I used MySQL for years with PHP, and then I learned about managed code, and it cuts development time in half or more, and now I'm never going back.
Yes you have to pay for the other people's databases, but in the long run you save money by making it easier to develop for and manage.
Score: 0
|andrewfit,
They are available, which piece would you like? I develop in VS against both SQL and MySql and they feel exactly the same. The .NET DataProvider for MySql is just as robust as the SQL Server one and even includes a DBBI-style class.
Score: 0
|Congrats MySQL team! Now that 5.0 is stable with sprocs I would finally consider using it. Can't wait to play with it!
Score: 0
|