Documenting MySQL Tables in MediaWiki

March 11, 2013 | Comment

The last few companies that I have worked for we have setup an internal wiki that everyone uses to hold information about all aspects of the business including, of course, the technical team. We use MediaWiki for this mainly because it is easy to setup and is also familiar to users through Wikipedia.

One area that we try and document is the database structure. Having this on hand and searchable in the wiki allows new employees to quickly get to grips with it and makes us all more productive.

The issue is that creating the MediaWiki tables by hand is … Read the rest

Recognising the Opportunity: I Could Have Written WordPress

March 5, 2013 | Comment

Over the last few weeks I have been moving the content from one of my other sites, The Williams Database, to WordPress. This means that all my sites are now running on what I consider to be the premier content management system but if I had acted differently a few years ago that might have not been the case.

In 1996 I launched a fan site to the Williams formula one team. In those days there wasn’t much of an internet to speak of, connection speeds were slow and access was costly but it was new and great fun. … Read the rest

Using Google Docs to View PSD files

February 18, 2013 | 3 comments

Spotted this on Twitter today and thought it was a great tip for those, like myself, that occasionally get sent Photoshop images for review but don’t have Adobe’s software to open the file.

It would appear that Google Drive has the ability to read and display PSD images along with the more standard office documents.

More details from Digital Inspiration.… Read the rest

Google Authenticator Bug

February 1, 2013 | 1 comment

I am a big fan of Google’s Autheticator app which adds 2-factor authentication to a number of popular apps including Dropbox, WordPress, LastPass and, of course, Google accounts.

Since my mother-in-law’s GMail account was compromised and she wasn’t able to recover it I have considered the use of 2-factor authentication as mandatory rather than a nicety.

What this means in practice is that in order to access your account you need something that you know (the password) and something that you have (your phone). This should considerably increase your online security as if anyone does get your password they still … Read the rest

Embedding docs

January 17, 2013 | Comment

In my previous post I included a viewer that allowed you to page through PDF file. This used the Google Drive (nee Docs) Viewer.

You may already be familiar with this for viewing attachments in GMail and documents in Google Drive but you can also access it directly using the snippet of code shown below:


<iframe src="https://drive.google.com/file/d/0B8p1gAHHCMytS3ZrazdoRWVZVmc/preview" width="640" height="480"></iframe>

According to the documentation Google Drive viewer allows you to preview over 16 different file types, listed below:

Image files (.JPEG, .PNG, .GIF, .TIFF, .BMP)
Video files (WebM, .MPEG4, .3GPP, .MOV, .AVI, .MPEGPS, .WMV, .FLV)
Text files (.TXT)
Markup/Code (.CSS, .HTML,

… Read the rest

Roll your own Dropbox with a Raspberry Pi

January 7, 2013 | Comment

Following the success of hooking up my Raspberry Pi to my BT Home Hub the next step was to do something useful with it.

I am a very active user of cloud services, particularly Dropbox and Google Drive. Both work well but in order to gain additional space you have to pay but what if you could run your own service and add as much storage as you liked? Enter ownCloud a Dropbox lookalike that you run on your own server.

In my case the server is my Raspberry Pi and a 500gb harddrive attached providing the storage and it … Read the rest

Time to re-evaluate Flickr

December 18, 2012 | Comment

The blogsphere is all abuzz with Instagram’s proposed change of terms of service from the middle of next month which some have already dubbed “Instagram’s suicide note”. Basically the changes give Instagram (or parent Facebook) to sell your pictures of which you get no portion of that sale or any choice in the matter.

You can read a good summary of the situation over at c|net but I am already considering whether I want someone else to have such control over work that I produce and I am thinking that I don’t. I still have a Flickr account that I … Read the rest

Google Analytics – the Videos!

December 16, 2012 | Comment

Shopping online can be an absolute godsend but it can also be a complete pain in the arse. Google clearly recognises that’s a problem for many and that the issue is the user experience offered by so many websites.

How do I know that they understand the issues? Because they have produced a series of humorous videos that highlight a set of common issues on shopping websites and apply those issues to real world scenarios. The three videos are embedded below, my favourite being the checkout one.

What I found quite surprising about the videos is that they are clearly … Read the rest

Hacked Off (again)

December 9, 2012 | Comment

A dozen years ago, when the web was a very different beast to what it is today I, wrote a series of scripts in the language Perl what was a simple content management system (CMS) to run my websites. Those websites have run using those same scripts with little change over that time. Now I only have two sites left on that infrastructure and after a hacking this week I have decided that it is finally time to retire the scripts and more the sites to WordPress. I am a bit sad to have to scrap my work but I … Read the rest

The Chubby Challenge

November 13, 2012 | Comment

One of the great things about the Internet is that it allows new ideas to be quickly built and got into the hands of the public without having to spend huge amounts of cash. This has allowed countless number of people to become entrepreneurs even if only in a very small way. And now it is my turn.

For the last few months I have been working on a new project called The Chubby Challenge which is based on something that we used to run when I was working at AppSwing.

Most office workers seem to lead a sedentary lifestyle … Read the rest