The MySQL monitoring feature includes 246 monitoring variables
and more than 21 different metrics to provide one of the easiest
to use, yet comprehensive database monitoring tools available. It
was first introduced into the free Monitor.Us platform back in
June last year and has seen the code battle hardened by many
hundred free users over the last 8 months.

MySQL Workbench is a great tool for developers to map out and
visualise databases. What many people know is that it’s also a
great way to make upgrading and writing upgrade scripts for your
components really painless too.

Let’s say you created a small component that became popular over
night. Tens of thousands of downloads from on the Joomla
Extensions Directory. So you get inspired and put some more work
into improving and bugfixing this component even more, and while
doing that you change and add on to the database schema.

Now you need to create and distribute an update script with the
next version of your component, and MySQL Workbench makes
creating this update script really easy. Here is what you need to
do:

Back in 2006 I was a member of the standards and guidelines
workgroup in Joomla, and during my involvement there I produced
the Joomla 1.5 database schema as a DB Designer
EER diagram, so people could view the database in a visual way. I
recently also set up the Joomla 1.6 database schema, this time using
MySQL Workbench which is a better tool for the job, and also GPL
and available on multiple platforms. During my work with setting
up the 1.6 schema, I came across lots of oddities and lacks of
normalization, and a severe lack of naming conventions and
guidelines became obvious.

Improvement suggestions

I have listed a few of these below, and please add comments to
this post if you find some of your own or you disagree with me,
and …

As some might remember I made a visual
representation of the Joomla 1.5 database schema back in 2006. I
have now set up an EER representation of the Joomla 1.6 database
schema too, that you can download for free. This schema was made
after the 1.6 beta 2 release, and it was built using MySQL Workbench, which
is both GPL and available as a free download for multiple
platforms.

First of all: If you find any errors in this schema, make sure
you leave a comment for me at the bottom. Because of the lack of
conventions for naming primary key columns, I am left to do a lot
of guesswork here when drawing up table relations, so there may
be errors. Pretty much the only table …

Yesterday I had a look at the response of the Joomla! community
to the news that Microsoft had signed the Joomla!
Contributor Agreement and was contributing code to the content
management project.

You probably won’t be surprised to find that some people don’t
like the idea. The speed and vehemence of their rejection of
Microsoft’s involvement in the project is entirely predictable,
but none the less depressing for that.

The usual complaints were rolled out:

you can’t trust Microsoft

when Microsoft contributes a major product to open source, we’ll
listen Microsoft is only doing this to sell more proprietary
software

.
Taking those in reverse order: yes Microsoft is doing this to
encourage Joomla developers to use Windows. Just as IBM supports
Linux to …

I’ve already noticed that Joomla users are a slightly different
crowd. Joomla is a pretty powerful CMS with many
modules/extensions, just like Drupal which runs the Open Query
web site. I’m not sure the two even compete directly although
there might be some overlap. It occurred to me that Joomla might
be what I would call an “enabling technology” on the
web, just like PHP and MySQL have been since 1995. It has a very
easy entry, which of course is both good as well as bad. Again
that’s quite similar to the M and the P…. love it or hate it.

I’m kinda agnostic on the subject of CMSses, there’s quite a few
out there and I think that most of the …

Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.