MySQL 4.0: Teaser for 4.1
By Timothy Dyck
November 12, 2001
MySQL AB\s MySQL has proved itself as a light, fast database for non- mission-critical applications. The alpha release of Version 4 (specifically Version 4.0.0), posted for free download last month, lets developers kick its tires in preparation for a beta release by year\s end and a stable release early next year.
There isn\t 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 MySQL\s text search engine.
An important part of MySQL\s appeal is its excellent multiplatform support: It runs on Linux, Windows, and on Solaris, Mac OS X and other Unix operating systems.