Five Questions With Michael Widenius

volume4 writes "With two MySQL execs leaving Sun in the last week, the internet is buzzing about what is going on at Sun, what is the future of MySQL and what lies ahead for Michael Widenius. Over at Open Source Release Feed, Widenius spoke candidly regarding his split from Sun, the future of MySQL, Monty Program AB, and the open source ecosystem in general."

Comments

Re:Good he could sacrifice a good 30 seconds

[musicmaker]

Two words: Explain Plan
Three More: Share nothing cluster
A date: '00-00-0000 00:00'
Two More: Silent truncation
One acronym: MVCC
Result: Nobody in their right mind uses MySQL.

LAMP has it's place, it's at the bottom of a trash heap. Ever tried to write business objects in PHP? What about dependency injection? Database abstraction? (let's face it PDO is a joke). Hell even prepared statements are a pain in PHP/MySQL (only exist in mysqli, and the implementation is horrible). AOP? You can't even do connection pooling for goodness sake because they turned it off in mysqli, and you need your head read if you are using the regular mysql libraries where the solution to injection attacks is to escape quotes and pray. Do you know how long it takes PHP to parse 80,000 lines of libraries every time a script runs because there is no persistence between requests, so PHP has to parse everything over for each request.

MySQL where foreign keys are silently ignored if you forgot to set your table engine to InnoDB. Where aggregates don't work right, where self referencing updates don't work, so you have to write a program to do what other RDBMSes can do in a single statement. Where your table names are case sensitive, but your text matches aren't.
Where you don't have sequences to generate globally unique ids, where bit fields work like a boolean half the time and char half the time. Where mysqldump locks half your database and doesn't get everything by default which you find out too late because you didn't know any better.

Apache where the recommended default for MaxClients is 256, which anybody with a clue knows is insane for dynamic websites, but most sysadmins put in anyway. PHP that hasn't been bothered to update itself to work with a threaded Apache that has been around for a decade.

I could go on for ages and ages on this stuff. I mean there are SO many issues with LAMP, it's a minefield. LAMP fails when you need it most, when traffic starts getting heavy.

OR

you could use a system that separates components into libraries and interfaces, allows you to modularize, allows database independence, makes testing easy, has static typing so the compiler can catch 80% of problems before they ever get executed. Has AOP, has IOC that isn't insane and is used by more enterprise shops that anything else.