Having bridged Gallery2 into Joomla 1.0.13 with the Gallery2 Bridge component all I needed to do then was be able to display images from the Gallery in my content. This plugin fo the Tinymce editor did the job admirably.

It was a little fiddly to install as you have to manually edit some paths in the config file and also the tinymce.php file; but once this was done it all worked very well.

The range of features in this plugin are impressive and it was well worth the little time it took to install.

Having written a prototype component to produce a single table of data from my MySQL database I then discovered DBQ and found it could do everything for me! As well as querying and displaying the data it will build forms to allow users to enter search or other criteria and so can be used to develop web based applications.

The free component provides most of the features you'd want to use; but for a fee the Professional version provides all the bells and whistles too, like the ability to preload data into the form. It also comes with a professional template that provides a much more attractive rendering of the results as well as enhanced sorting and filtering. Of course you can develop your own display templates if you want; but this just about does it all.

I only had one niggle and that was with the Professional template. When I tried to run this I initially got back a lot of 'Errors' from PHP. TCP (DBQ author) pointed out that these are not 'errors' but are 'Notices' from PHP that there's things like variable type mismatches in the PHP code. Basically this was due to running the template on PHP5, the notices can be disabled from the PHP configuration files. However I spent a long time actually debugging the template code to remove these to avoid having to turn notices off in PHP.

Having said that I still class this an excellent component. Now that it's fully working the features are extensive and most impressive.