Category: Programming

February 24, 2018

MySQL: Changing Date Format

I have needed to import a significant amount of information into MySQL from spreadsheets, where a date/time entry is in the format of DD/MM/YYYY...

Continue Reading
February 21, 2018

Remove Public Holidays from MySQL Results

I have needed to extract information from a MySQL database on a regular basis and present the information in the form of ‘business hours’....

Continue Reading
February 12, 2018

MySQL limiting selection to business hours

  I use MySql on a semi-regular basis to analyse data to determine trends and basic statistical information (e.g. min / max / avg)...

Continue Reading
February 1, 2017

MIDI2LR and the BCF2000

MIDI2LR, and the BCF2000 MIDI board provide and incredible way to speed up your lightroom editing, have a look at how...

Continue Reading
August 6, 2016

Raspberry Pi GPS by Hardware UART

I needed to use the raspberry pi 2 (Debian Jessie) as an embedded devices and wanted it to be location aware. This tutorial shows...

Continue Reading
August 13, 2015

Openseadragon and WordPress

A number of the images I display on this website are of high quality, and because of that if the whole image were to...

Continue Reading