Microsoft's Visual Studio courts database pros

TalkBack 29 of 31:

Next »

« Previous

• Thread View
• Flat View

Now, see, DonnieBoy,

if only you’d said that the Pros use Oracle or DB2 or SyBase instead of PostGreSQL and MySQL, your message would’ve had more respect.

MySQL 5 came out recently, and is the first version to have Views, Stored Procedures, and Triggers. Those are necessary for serious business purposes. It took MySQL five major versions to get that. It took them until version 4 to get ACID-reliable Transactions (also mandatory for business purposes), and then only with a plug-in InnoDB database engine instead of the native engines (granted, the plug-in database engines themselves are a great feature).

MySQL does have some cool features such as Enums and Sets as data types, three-byte "medium ints" for when two bytes is insufficient but four bytes is overkill, etc.

But enterprise DBs need more than cool features. They need data mining, analyses (cubes, rollups, and multi-dimensional queries), XML data, fuzzy logic full-text searches, and much more that MySQL still doesn’t have.

It doesn’t matter if your Schwinn is more reliable than a Boeing 747. If you need to fly hundreds of people across a continent, a bicycle just won’t do.

Posted by: Joel R   Posted on: 06/01/06 You are currently: a Guest | Members login | Terms of Use

Alert moderator to an offensive message

Subscribe to this discussion via Email or RSS

SponsoredWhite Papers, Webcasts, and Downloads

• Why Isn't Server Virtualization Saving Us More? A Few Small Changes May Dramatically Increase Your Efficiency VMware Companies have rapidly adopted server virtualization over the past few ... Download Now
• Three Steps You Need to Know to Stop Data Loss Varonis Sensitive data exposed to misuse or loss... it is the stuff of nightmares ... Download Now
• Virtualization: Architectural Considerations And Other Evaluation Criteria VMware Of the many approaches to x86 systems virtualization available in the ... Download Now