August 2010

Monthly Archives

Migrating the Department for Transport website to WordPress

From the conclusions made in the article UK government’s spending on hosting and development, I decided to migrate the Government site DFT (Department for Transport) to a php application, specifically WordPress, as this is a CMS we have much experience developing and hosting.

Summary

The key points from the rest of this report follow:

Migration – We migrated dft.gov.uk from it’s current management system to WordPress to illustrate the ease of the process and that the site can be moved to an open source, free management system for very little cost. We had no access to any site files but used a small script to crawl the sites content and images.

Hosting – The copied site is now hosted on our PHP platform vCluster and was developed on the same platform it is now hosted on.

Expenditure – The migration and hosting process resulted in costs to us of £5000. This small investment could save up to £64,800 per month, £777,600 per annum, and this is for a single Government site.

Read More

How accurate is Alexa?

Alexa Internet is a web company owned by Amazon that provides a toolbar that offers advice to it’s user on navigation, and tracks a users behaviour transmitting it to Alexa for analysis of browsing patterns.

Alexa is widely used, especially when attempting to value a website for a potential sale. Some Webmasters focus on improving their Alexa ranking over improving their content in the pursuit of valuing their site higher. This seems like a waste of effort to me, but this practice does take place, but then you already knew that! With this behaviour taking place, and discrepancies when comparing Alexa rankings with analytic services such as Google’s, some concerns over Alexa’s accuracy have been raised.

Read More

MySQL Best Practices

Do you know how to best design a MySQL database, or how to best structure a MySQL query? If not then this post will certainly interest you.

Here we will be discussing the best MySQL practices you can use not only to keep your database running smoothly and quickly but also to keep it user friendly.

10 – Use sensible field names

Have you ever started on a project and designed the database using ambiguous field names like Read More