Articles about MySQL

A web site to support the Reforestation of the Atlantic Forest

The Royal Botanical Gardens at Kew engaged us to convert an existing MS Access desktop database into a multilingual CMS based web site. The site is a responsive mobile and tablet friendly CMS based web site that enables the management of a database of tree data for conservation purposes. The data relate to trees native to the Atlantic Forests of Brazil that could be used for reforestation - The South Eastern Bahia Atlantic forest database.

Relational Division

Sometimes you come across a problem in SQL that is far more complex than you first imagine. One classic of these is 'Relational Division' - a poorly understood aspect of SQL that can help answer what must be a common question:

Return the things that have all of the items in a given list

Example questions:

Binary logs are filling up my Mac - Help!

A colleague of mine was running out of disc space on his development machine and on inspecting the disk space usage (use - found that MySQL was using up the bulk of the disk.

Importing Products Displays and related Products to Drupal Commerce

In this post I am going to look at Drupal Commerce and demonstrate how to prepare e-commerce product data for import into Drupal Commerce - and show how to create a delimited list of product references to link the products to their display nodes. These techniques supplement the wealth of great practical demos and documentation provided by the Commerce team.

History of Parliament Online

We were engaged by the History of Parliament Trust to work on their flagship website that publishes the results of research into the members and constituencies of all British parliaments since 1386. This data rich web site is managed by the Drupal CMS and has tens of thousands of 'nodes'. We were tasked with solving various issues with the site's performance and importing data from the DTP files used to create the published volumes.

Technology Articles

Update: we have now combined this site with our main site! And all the articles are available in the one site.

We wanted to create a home for our knowledgebase and created the website Here we provide a range of articles and posts covering issues from using CMS systems such as Drupal through to security articles covering securing access to your website.

Species Protection Legislation

Over ten years ago when we started creating web sites and applications to manage biodiversity related information we needed a public website to act as a host for these projects. was created to provide web space for not for profit Biodiversity and conservation projects and provide resources for biodiversity projects.

The Species Dictionary at the Natural History Museum

To create an online representation of the NBN Species Dictionary. The required version was to be a simple reflection of the structure of the data model to highlight the concepts and the content of the standards promoted by the Species Dictionary.

Encryption of 1:50,000 Ordnance Survey maps for Recorder

To enable the secure distribution of the 1:50,000 Ordnance Survey map series for use with the Recorder 2000 application. The maps were to be encrypted and supplied on CD. Users of the CD set should be able to apply for unlock keys for maps, to which they access, by email, fax or post. Once unlocked, the maps should be automatically installed for use with the Recorder 2000 software.