IBM, MS Critique MySQL
magellan writes "InfoWorld has an article reporting how both IBM and Microsoft are dissing MySQL. While it is understandable from Microsoft, it is interesting that IBM, who often claims to be a defender of Open Source Software, would be so negative. Sun Microsystems and Yahoo are quoted as providing positive opinions on MySQL." On the credit site for MySQL, though, Bingo Foo writes "MySQL has finally answered its detractors who complained about its lack of transactions. A press release today reveals that InnoDB is now fully integrated with the stock MySQL product, allowing ACID-compliant transactions, rollback, and crash recovery. Let the religious wars begin!"
Something Free- is always going to be put down by something that another company can make money off of.
www.oobersworld.com - For those that ride.
If they're there in a later release, I'll probably use them, but only because I'm lazy. Views are also one of the worst pigs ever created.
Now, triggers I'm of two minds about. Simple triggered events (e.g. tbl1.col1 = f(tbl1.col2) where f is a basic, internal MySQL function) should be supported, no doubt about it. But, if what you want is to tie a program to updates, then I think an event model for external applications would be a much better way to go.
However, if you're not of the "treat the database like hardware" camp that I'm in, you'll be happy to hear this:That's from the 4.0 "in a nutshell" page. 4.0 is currently in beta, though if previous MySQL releases are any indicator, don't expect it to be out of beta right away. They're pretty fanatical about stable releases.
If you start converting now, I imagine you should be in good shape by the time 4.1 is out. Good luck!