MySQL 4.0: Teaser for 4.1

By Timothy Dyck  |  Posted 2001-11-12 Print this article Print

MySQL Ab's MySQL has proved itself as a light, fast database for nonmission-critical applications.

MySQL Abs MySQL has proved itself as a light, fast database for nonmission-critical applications. The alpha release of Version 4 (specifically Version 4.0.0), posted for free download at www.mysql. com last month, lets developers kick its tires in preparation for a beta release by years end and a stable release early next year.

There isnt much in 4.0 for IT. The 4.0 release will be of interest mostly to software vendors wanting to embed MySQL into their code. (The server now comes in a library version for linking into existing applications.)

The big database features we were really looking for have been pushed back to Version 4.1 of MySQL. The 4.1 release is expected to have foreign-key support, subqueries and support for stored procedures—all key things MySQL needs to enter the midrange database market.

Version 4.0 does gain support for the SQL union keyword (used to combine results of two queries); the SQL delete command can delete rows from multiple tables simultaneously (for cascading deletes); and the client and server can now encrypt communication between themselves using SSL.

Subsequent releases leading up to the final 4.0 release will add improved replication support and Boolean support in MySQLs text search engine.

An important part of MySQLs appeal is its excellent multiplatform support: It runs on Linux, Windows, and on Solaris, Mac OS X and other Unix operating systems.

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