Georg Richter, Apache, PHP, and MySQL hacker finally has a blog!

The new version of my Normalization article is now online:

http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html

Apparently SCO is trying to push it's OS with a new Product - SCAMP, a LAMP-like combination of OpenServer, Apache, MySQL and PHP/Perl. Unfortunately for them the abbreviation is already an english word.
Leo says in german it's "Schuft, Spitzbube" as a noun and "pfuschen" as a verb. Should this tell us anything about the product? This reminds me of the short-lived slogan of the Deutsche Bahn "Geniessen Sie Ihr Leben in vollen Zügen" (Enjoy Your life to the fullest / Enjoy Your life in overcrowded trains). But who's to blame, our latest product is named Chorizo :-)

The MySQL GUI team, under the leadership of graphical guru Mike Zinner, has posted a new beta version of MySQL Workbench.  This is a brand new graphical tool targeted to DBAs giving them a powerful graphical environment for modeling and managing database schemas.  This is an awesome tool that makes it easy to reverse engineer huge database schemas, maintain the model graphically, and it provides complete 2-way synchronization between the graphical model and the underlying database schema.  It provides automatic layout, customizable views, drag and drop capabilities and more. 

MySQL Workbench runs on …

from this thread on the orafaq forum:

?There is no way we would be able to raise the money required to buy a commercial Oracle license.?

?I believe the XE edition is a max of 2gig. htmldb would be free for that, but by the time you add htmldb overhead and users, I gotta think this site has way way more data than what is left out of the starting 2gig. ? Standard Edition One would be the next option, at 5 grand per proc.?

maybe oracle will toss a free license their way, but this is a great case study on how useless oracle?s free offerings really are. (to contrast, of course, mysql?s free offering is fully-featured, with no artificial limitations. same with other truly free databases like firebird or the open-source versions of …

Ok, I just had to laugh.  The Oracle FAQ site OraFAQ runs on... MySQL!   I guess it just goes to show how cost-effective open source is.  Here's some quotes from a thread on their discussion forum:

"Interesting - we don't run an Oracle database. But I suppose we ARE a free site so are probably a bit short of cash.

David "

...

"What cash? Every penny we make goes back into running and developing this site. There is no way we would be able to raise the money required to buy a commercial Oracle license.

Best regards.

Frank

To be honest, it's not a surprise.  There are tens of thousands of web sites that run MySQL ranging from the mega sites like Yahoo, Google, Craigslist, Travelocity, to many ecommerce sites, blogs, forums, and discussion sites.  After all, …

I'll be speaking at the Open Source Software Forum on April 6th in Hobart, Tasmania. Speaking, I say? They offered me the keynote straight after the minister's intro. Grand!
I've been asked to talk about "bridging the divide between bright developers and the real world", basically a mix of my "How to Eat an Elephant" and "The MySQL Business Model" talks.

There's a serious crowd of OSS and other software vendors present, I've seen names from Red Hat, IBM, and Microsoft. The website explains
The forum will be used to promote awareness and understanding of OSS and to examine the risks and benefits associated with the adoption of the software. The forum will also provide an opportunity to showcase OSS solutions using case studies and/or pilot programs discovered via market research. The forum will involve stakeholders from within …

The phpMyAdmin project will be participating in the DotOrg Pavilion at the MySQL Users Conference. Marc even put up a banner for it on their site - thanks!

There's a whole range of UC banners available at http://mysqluc.com/images/mysqluc2006/banners/ (they should link to http://www.mysqluc.com/)

Whenever we are faced with a choice between two designs, and the first design is upward compatible with the second (i.e. the first design is more restrictive, and implementing design two would not affect functionality provided by design one), and the full impliciations of the second design are not yet known, the first design choice is recommended.
Formulated by C.J. Date in "Relational Database: Writings 1989-1991"

MySQL 5.0 has a ton of new features. In fact, several tons. Many people and companies were waiting endlessly for some of these features. Some of the new features include: Views, Stored Procedures and Stored Functions, Triggers, and some extra optimizations. Hoorah.

However, not all is peaches. In fact, there are few peaches to be found. Consider the rest of this post a bitch/complaint session and a call for a return to sanity. Let’s take a look at some of the major features of MySQL 5.0:

Views — Views are a …