Slashdot Mirror
Sun Announces New MySQL, Michael Widenius Forks
viktor.91 writes "Sun Microsystems announced three new MySQL products: MySQL 5.4, MySQL Cluster 7.0 and MySQL Enterprise Partner Program for 'Remote DBA' service providers."
which showed up in the firehose today next to Glyn Moody's submission where he writes "Michael Widenius, founder and original developer of MySQL, says that most of the leading coders for that project have either left Sun or will be leaving in the wake of Oracle's takeover. To ensure MySQL's survival, he wants to fork from the official version — using his company Monty Program Ab to create what he calls a MySQL "Fedora" project. This raises the larger question of who really owns a commercial open software application: the corporate copyright holders, or the community?"
Did anyone else notice that his little toy database is practically useless without InnoDB, which was written by a third party and is owned by Oracle?
If you mean for transactions.
If you want a really fast free database that supports fulltext indexing, and you don't need transactions, MyISAM in the engine to use.
If MySQL had a BSD license it would be owned by the community.
If MySQL had a "non-free" commecial license it would be owned by Oracle.
The mess MySQL, and you, find yourselves in is because of MySQL's stupid dual-level license bullshit. Nobody seems to be able to figure it out or agree on it and it has caused more column inches of claptrap on Slashdot than the MySQL/PostgreSQL threads themselves. MySQL's originator's wanted to have it both ways: Lots-O-corporate money AND GPL poster child. Well they got their money alright, but to get it they had to pray for a really wealthy, poorly managed corporation to come along and vet their convoluted business plan. That would be Sun.
Now, with a billion dollars spent to "buy" MySQL but a bunch of forks still out there, no company in their right mind is going to invest anything in MySQL because they'll be worried Widenius will just steal the improvements and fork it again. MySQL is pariah, it's poisoned.
If you're running any kind of data volume worth talking about you're better off with PostgreSQL. Not only is it faster with *real* queries and more robust, but now it's safer going forward.
SQlite has supported per-table locking for a while, and I believe it supports per-row locking in some situations. It is not designed for concurrent writes, but it can be great for anything read-heavy workloads. It's certainly not suited for situations where you have a lot of concurrent writes, but for a CMS it can be a very good fit.
If you want full-text indexing, transactions, and lots of concurrent users, PostgreSQL is generally a better bet. MySQL is being squeezed at the bottom by SQLite and at the top by PostgreSQL, and both have less restrictive licenses (public domain and BSD, respectively). I'm amazed that it's survived this long.
I am TheRaven on Soylent News
What do you think most companies do with an RDBMS if they are not building software on top of it?
Most people don't build software on top of an rdbms, they build software that uses and rdbms as a backend data store.
Dual Opteron < $600