Users tempted by free commercial databases
Open-source versions like MySQL sometimes get the boot
March 2, 2006 12:00 PM ETComputerworld - Missouri State Universitys information systems department and Web start-up Savvica Inc. dont have a lot in common apart from tight budgets. In recent years, that would have likely meant choosing a free open-source database such as MySQL or PostGres.
But last month, both eschewed open-source, opting instead for different commercial databases -- albeit the free, stripped-down versions.
Everythings so much more solid now, said John Green, president of technology at Toronto-based Savvica. Burgeoning Web traffic was causing Savvicas MySQL server to continually crash, and the companys e-learning applications were written in Java, which Green felt was not well supported by MySQL.
Instead of adding more MySQL servers, Green chose to roll out three of IBMs new DB2 Express-C databases managed by a load-balancing application from another Toronto firm, Xkoto Inc. DB2 Express-C just feels like a much more profound piece of software, he said.
Using the open-standard JDBC interface, Savvica ported its data to DB2 Express-C from MySQL in less than a day, said Green.
Defections such as Savvicas hearten big commercial database vendors, including Microsoft Corp., Oracle Corp., IBM and even Sybase Inc., which have all released free express databases in the past six months.
Despite more robust features, these hugely profitable databases have in recent years lost mind share -- and, increasingly, customers -- to their open-source counterparts. MySQL ABs success has epitomized the corporate revolt against the license and support fees charged for commercial databases.
But the free express databases are significantly challenging the conventional wisdom about commercial vs. open-source databases, said Peter OKelly, an analyst at Midvale, Utah-based Burton Group.
The commercial database vendors are opening a second front by adding support for application frameworks popular with open-source users. On Tuesday, Zend Technologies Ltd. released software that enables developers to write applications interacting with the Oracle database in the PHP scripting language.
IBM and Oracle are doing something similar to what MySQL has done: win the hearts and minds of developers by giving them easier access to technologies, said Mike Pinette, Zends vice president of business development.
Its early, and the success of the big commercial database vendors at wooing back software developers -- who wield increasing influence over corporate buying decisions -- is not yet clear.
In the area of database instructional book sales, considered a good indicator of developer interest, sales of SQL Server how-to books have surpassed MySQL books this year, according to Roger Magoulis, director of research at leading publisher, O'Reilly Media Inc. He believes that interest is due more to the general release of SQL Server 2005 last fall, rather than just its free edition -- especially as sales of Oracle or DB2 how-to books have inot ncreased significantly since the release of their free versions.
Databases
Additional Resources



Learn the important issues you must consider before starting your next mobility initiative. Get your mobility white paper from IDC now, compliments of Sybase.
White Papers & Webcasts
The Commercialization of ITIL: Lessons Learned
Register for this event today!
Oracle Accelerate - Not Just Smart but Timely
Download Now!
Key Findings: Accelerating ROI with BPM
Click here to watch now!
Why BI is Ripe - Now! - For Businesses of Any Size
Download Now!
Data Protection is not an insurance policy -you cannot buy-back lost data
Find out why you need to maintain access to critical information to run your business and remain competitive.
