| By SOA News Desk, Stephen L. Michel | Article Rating: |
|
| April 16, 2005 12:00 AM EDT | Reads: |
16,413 |
There are a lot of reasons for this, but the overarching one is the recent releases of two versions of the database program, giving it new features that make it much more palatable for database traditionalists and likely making it more welcome in IT departments. MySQL Version 5.0 promises more features that will likely make it more welcome in IT departments, alongside Oracle, Microsoft SQL Server, and Sybase SQL Anywhere. This in turn should further validate LAMP as a viable application development strategy.
The first release was that of version 4.1 a couple of months ago. The most notable new capability in 4.1 was support for subqueries, which allow one query statement to be comprised of several queries. Subqueries, and correlated subqueries are essential for creating sophisticated applications. Entire chapters of books have been written explaining how to get around the lack of subqueries.
Virtually every other SQL implementation supports subqueries. Without them, MySQL felt a lot like a toy. With the release of 4.1, you don't need to worry about that anymore.
But the really big step is the release, in beta form, of version 5.0 of the server. Version 5.0 finally adds support for several big features of relational databases: views, stored procedures, user-defined functions and triggers. Views let you create "virtual tables" that can be addressed the same way as regular tables, but which comprise several different tables.
Stored procedures let you store sequences of SQL scripts in one named procedure, which can then be called from other programs. User-defined functions allow you to use SQL to extend the language, and provide shortcuts to complicated procedures. Finally, triggers are ways of programming the database engine to react to certain events in the database--inserting, changing, or deleting rows, for example.
Not all of these features is perfect. For example, functions can not query tables, which places severe limits on their usefulness for such things as data validation in trggers. The implications of some features on such things as database optimization is not clear yet, either.
But the upshot of all these anguage changes is to add features to the server that bring it more in line with other big database products. As a SQL developer, I appreciated 4.1 a lot because it saved me time in having to write code that worked around limitations in MySQL itself. Using it was a liberating experience.
I look forward to 5.0's new features, for a lot of reasons. For one, it will remove the burden of scripting in the host language (I usually use PHP), and let me move some standard logic into the database layer of my applications. This means that I can create standard interfaces in the database which can be used from various host languages without having to re-invent the wheel every time.
MySQL will always have its skeptics. This is an area where things can get religious quickly. There are those who frown on features added to SQL by Microsoft, for example, and different points of view about what belongs in the database layer versus what belongs in the application layer.
But it's clear that with the imminent release of 5.0 in production, MySQL is here to stay. From the looks at the number of add-on products being touted at this week's show, a lot of vendors are betting on it.
Published April 16, 2005 Reads 16,413
Copyright © 2005 SYS-CON Media, Inc. — All Rights Reserved.
Syndicated stories and blog feeds, all rights reserved by the author.
More Stories By SOA News Desk
SOA World Magazine News Desk trawls the world of distributed computing and SOA-related developments for the latest word on technologies, standards, products, and services and brings key information to you in a timely and convenient summary form.
More Stories By Stephen L. Michel
Steve Michel is a developer and writer living in the Berkeley, CA area.
- 4th International Cloud Computing Conference & Expo Starts Today
- Deputy CIO of the CIA to Keynote 1st Annual GovIT Expo
- Publishing Synergy: Blog, Twitter and Ulitzer
- Cloud Computing Expo: Exclusive Q&A with Yahoo! SVP Cloud Computing
- Performance Tuning Essentials for Java
- Cloud Expo New York Call for Papers Deadline December 15
- IBM Hardware Chief, Intel VC Exec Arrested in Insider Trading Scam
- Cloud Computing Can Revitalize Your Career as Software Developer
- Open Source Mobile Cloud Sync and Push Email
- SOA World Magazine "Readers' Choice Awards" Voting Is Now Open
- Oracle+MySQL Opponents Take to the Barricades
- SpringSource Moving to Spring 3.0
- 4th International Cloud Computing Conference & Expo Starts Today
- Deputy CIO of the CIA to Keynote 1st Annual GovIT Expo
- Publishing Synergy: Blog, Twitter and Ulitzer
- Cloud Computing Expo: Exclusive Q&A with Yahoo! SVP Cloud Computing
- Performance Tuning Essentials for Java
- Cloud Expo New York Call for Papers Deadline December 15
- IBM Hardware Chief, Intel VC Exec Arrested in Insider Trading Scam
- Oracle-Sun: IBM Reportedly Behind Delay
- Citrix Aims To Cripple VMware’s Cloud Designs
- Cloud Computing Can Revitalize Your Career as Software Developer
- Oracle Trashes HP Relationship for Sun
- Open Source Mobile Cloud Sync and Push Email
- After Ubuntu, Windows Looks Increasingly Bad, Increasingly Archaic, Increasingly Unfriendly
- SCO CEO Posts Open Letter to the Open Source Community
- Simula Labs Launches Hosted Delivery Platform To Enable Enterprise Open Source Adoption
- Where Are RIA Technologies Headed in 2008?
- Source Claims SCO Will Sue Google
- How Open Is "Open"? – Industry Luminaries Join the Debate
- Latest SCO News is Plain Weird
- IBM Tells SCO Court It Can't Find AIX-on-Power Code
- SCO Claims Linux Lifted ELF
- Flashback: Investing in 'Professional Open Source' - Exclusive 2004 Interview with David Skok, Matrix Partners
- HP Starts Pushing Desktop Linux
- Linux Business Week Exclusive: Linux Kernel To Be Re-Written To Counter Microsoft FUD





































