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.

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.

MySQL connection (resource) management

Posted in Content management,Databases,PHP on Aug 18th, 2006

Just came across a good article by Jay Pipes talking about lazy loading and caching of content. A nice read with some good code examples that I thought I should share with my fellow readers. (more…)

Search and replace in MySQL

Posted in Databases on Jul 24th, 2006

I recently had to help a friend go through a site and correct alot of wrong URLs. Here is an easy way to do search and replace in MySQL, for those of you who didn’t know. (more…)

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