MySQL 4.1 Boosts SQL Compatibility

 
 
By Timothy Dyck  |  Posted 2003-02-10 Email Print this article Print
 
 
 
 
 
 
 

MySQL rolls out preview versions of the next release of its namesake database, as well as its upcoming MySQL Control Center, a Linux and Windows graphical administration tool.

Last month MySQL rolled out preview versions of the next release of its namesake database, as well as its upcoming MySQL Control Center, a Linux and Windows graphical administration tool.

MySQL 4.1, now in alpha (only source code is downloadable), gains subselect and subquery support. In so doing, it removes a major source of SQL incompatibility.

Version 4.1 also supports protocol encryption using SSL and gains Unicode data type support and makes a first attempt at handling special geospatial data types.

MySQL still has three major SQL limitations (lack of views, triggers and stored procedures) that the company hopes to address in a 5.0 release by years end. MySQL already supports transactions and foreign keys (its a common misconception that it doesnt).

There are third-party graphical MySQL administration tools, but MySQL Control Center is the first from MySQL itself and is already one of the best ones available. As with MySQL, it is free.

A few MySQL Control Center commands werent functioning in the current beta that I tried, but most features worked.

MySQL Control Center provides a query editor and results viewer; table and table data editor; and overall server administration features.

 
 
 
 
Timothy Dyck is a Senior Analyst with eWEEK Labs. He has been testing and reviewing application server, database and middleware products and technologies for eWEEK since 1996. Prior to joining eWEEK, he worked at the LAN and WAN network operations center for a large telecommunications firm, in operating systems and development tools technical marketing for a large software company and in the IT department at a government agency. He has an honors bachelors degree of mathematics in computer science from the University of Waterloo in Waterloo, Ontario, Canada, and a masters of arts degree in journalism from the University of Western Ontario in London, Ontario, Canada.
 
 
 
 
 
 
 

Submit a Comment

Loading Comments...
 
Manage your Newsletters: Login   Register My Newsletters























 
 
 
 
 
 
 
 
 
 
 
Rocket Fuel