It’s important that for any software application good standards exist. Standards ensure a number of key considerations. Standards are necessary to enforce and provide reproducible software and to provide a level of quality in a team environment, ease of readability and consistency.

If you were going to create a MySQL Naming Standard you have to make a number of key decisions. Generally there is no true right or wrong, however my goals tend towards readability and simplicity. In 2 decades of database design I’ve actually changed my preference between some of these points.

1. Pluralism

Option 1
All database objects are defined in the logical form, that being singular.

For example: box, customer, person, category, user, order, order_line product, post, post_category

Option 2

For database tables & views, objects are defined in plural. …

MySQL celebrates the 25th Anniversary of the GNU project this September.

Also, a community reminder that September 20 is "Software Freedom Day" around the World.

Mediargus, a leading online press service in Belgium, has recently subscribed to Sun Microsystems' MySQL Enterprise™ database subscription to cost-effectively support its fast-growing business. MySQL Enterprise is an affordable, comprehensive subscription offering that combines regular software updates of the world's most popular open source database -- along with 24x7 production support and proactive DBA monitoring tools.

So I gave up and tried 32 bit guests, just for the sake of testing and comparing.

I finally managed to get VBox functional on OS X.  Installed Ubuntu and discovered that I can lock up the VM at will by “ls -lR /”.  This only happens under OS X and actually reinforces my suspicion that my Macbook Pro has a hardware problem.  But maybe VBox is buggy on that platform.  I switched to Windows as the host OS for reliability (…)

I decided to try OpenSolaris (for the first time) under VBox.  I have a long-standing hatred of Solaris’ installation procedure and “user experience”, and have to say that Sun/We/Gaia are going very much in the right direction with this.  Gnu userland utilities would probably cause me to switch to OpenSolaris on my *desktop*, never mind the server.

Ubuntu “server” seemed to have mostly similar performance between VMware Server and VirtualBox.  Ubuntu …

Hartmut rules!It started during …

JasperSoft’s business development director Andrew Lampitt has kicked off his new blog with an interesting post related to business models used by open source-related vendors.

In it he attempts to define the approach utilized by the likes of JasperSoft and SugarCRM, which offer open source products with core functionality, as well as commercial extensions. The approach is a twist on the dual licensing approach made famous by MySQL* where the vendor, as copyright holder, makes the code available under both the GNU GPL and a commercial license for customers that would rather avoid the GPL.

The approach taken by JasperSoft et al is not to segment by user base but by features. As Andrew explains, “the commercial license is a super-set of the open source product, i.e., it offers premium product features that you will not see in …

Q4M (Queue for MySQL) Version 0.8.3 has been released with following Changes.

• fix race condition error that might lead to deadlock on shutdown
• support for FreeBSD

With support for FreeBSD added, prebuilt binaries are provided for the platforms below.

• linux (i386)
• linux (x86_64)
• freebsd-6 (i386) (should work on FreeBSD 7 as well with compat6x package installed)
• Mac OS X 10.4 (x86)

I'm back home from DrupalCon 2008 now - it has been a great event! I met a lot of nice people from the Drupal Community and learned a lot about this CMS. I've been very busy in uploading the remaining pictures from the event to my gallery - so here's for your viewing pleasure:

• Impressions from Szeged
• Day One - 2008-08-27
• Day Two - 2008-08-28
• …

Event Schedulers are "temporal" triggers.

More at http://dev.mysql.com/doc/refman/5.1/en/events-overview.html