MySQL Updates

My latest column is up on SitePoint and takes a look at the MySQL Roadmap.

Also – some MySQL news from yesterday:

A new maintenance release (4.0.20) was announced on lists.mysql.com by Patrick Galbraith, a senior software developer with MySQL. It can be accessed at http://www.mysql.com/downloads/.

For developers using OS X, Navicat has released version 5.1 of their popular MySQL GUI. This allows remote administration of MySQL database on numerous platforms from a 10.1 or greater version of OS X. This is a commercial tool but affordable for developers leveraged in MySQL development work at $95 US.

As of May 19th, MySQL Professional Certification is now available, with lots of detail available on the MySQL site, and access to study guides.

Free book: Jump Start HTML5 Basics

Grab a free copy of one our latest ebooks! Packed with hints and tips on HTML5's most powerful new features.

  • cholmon

    One thing I’d like to see added to the fold along with SPs, views and triggers, is native support for xml. So many applications could benefit from a well-formatted XML result set that comes directly from the DBMS, a la SQL Server:

    SELECT col1, col2 FROM table FOR XML AUTO

    …then you’d just have to shove the result through an XSLT processor and be done with it. I know PHP and Java both have SQL2XML-type utilities to handle this, but they are all implemented on the client side. It would be much quicker if the server could be given the responsibility to return the XML.

    Blane, do you know if there are any plans for something like this on MySQL’s horizon? I’ve looked through the docs at mysql.com but I can’t find any mention of XML used in this context.

  • http://www.practicalapplications.net bwarrene

    Looking into this cholmon. Great question. Of course they support xml on the mysqldump – but native storage would be a phenomenal functionality.

  • Steve Michel

    The FOR XML clause doesn’t really have anything to do with native storage of XML. Instead, in SQL Server, when you append the clause to a query, it returns XML instead of rows and columns. The XML is always well formed, and you can also get pretty sophisticated in specifying the shape of the XML. It’s a very nice feature in SQL Server, and would be really, really great in MySQL.

  • cholmon

    Yeah, newer versions of mysql (the cli utility) even tease us with XML resultset ability (can’t recall when support for this started):

    # mysql -u user -ppassword -D database –xml
    mysql> show tables;

    but I don’t usually use the cli utility in my web apps :P, so I’m stuck asking PHP (or whatever language) to do the job for me. I don’t know how drastically (if at all) it would change the mysql api, but good lord it would be convenient to pull xml directly out of the resultset.

    I’m sure implementing full-fledged xml support into the storage engine would be a pretty big undertaking, but simply formatting the results of a query as xml isn’t asking too much is it? 0:-)

  • http://www.sitepoint.com/ Kevin Yank

    Worst case, this is something that could be done with an especially clever stored procedure, once support for those is available and stable.

  • bhushanvinay@mail.com

    Hai is there any way where i can write mysql query as “Select * from emp for xml auto”
    or “select * from emp for xml raw”
    what i can use with mysql it dosnt work with Mysql.
    I cannot write a stored procedure or do any thing here they syntax is different can anny body sugest me is there any way msql will come up or is a download possible to fix these issues on windows aswell as linux.