Torkil Johnsen

My personal piece of cyberspace

Using MySQL Workbench to manage your Joomla component’s db schema

Posted in Databases,Software on Jul 23rd, 2010

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.

What is MVC, and why should I care?

Posted in joomla,Software,Standards on Jul 17th, 2010

Those of you following blogs and tweets in the Joomlasphere and reading about Nooku, might have read and learned about MVC and HMVC already. If not, here is a short explanation on MVC, and why you should care about design patterns and MVC in particular, especially if you’re a Joomla user. (more…)

What is this Nooku Framework thing really? And why should I care?

Posted in joomla on Jul 15th, 2010

Let me try to explain, in non-technical terms, what a framework is and why using the Nooku Framework is a good idea.

The Joomla database schema smells

Posted in Databases,joomla on Jul 12th, 2010

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.

Joomla 1.6 database schema

Posted in Databases,joomla on Jul 11th, 2010

joomla 1.6 database schema thumbnailAs 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.

Creative Commons License
This work by Torkil Johnsen is licensed under a Creative Commons Attribution-ShareAlike 3.0 Unported License.