Five zero-cost ways to boost MySQL performance

The internet runs on databases – without them, the way we live today just wouldn’t be possible. So, it’s not surprising there’s significant demand for greater database transaction speed to cope.
You can get that speed by throwing faster hardware at your database – but that should come only after significant database performance management. It seems everyone has their own idea of how to maximise database transaction speed, but the only way to find that out quantitatively is to benchmark… Read more

How to use my APC Arduino project code

Over the last little while, I’ve had a few readers looking for help on how to get started with Arduino projects and my APC Arduino Masterclass series in particular.
The first thing you’ll need is the Arduino integrated development environment or IDE – this is where you write your code or load my .ino source code (called ‘sketches’ in Arduino-speak) and program your Arduino Uno board. Grab this from¬†(Windows users, Mac OS X and Linux users can grab the… Read more

Linuxs distros and RDBMS Labs test for ITNews

After some long hours, I’ve just completed my first labs test story for Australian business tech news website itnews, looking at Linux distros and relational database management systems (RDBMSs) – MySQL and MariaDB, in particular.
All the major Linux server distros feature at least one DBMS, but working out which is the best combination would obviously take some serious time testing (hint: it does!), so I’ve taken the three most popular distros – CentOS 7.0, Debian 7.6.0 and Ubuntu Server… Read more

Enigma Cipher Machine story up at apcmag

The Arduino Uno microcontroller is a pretty impressive little number – so impressive, in fact, you can turn it into a fully-working Enigma Cipher Machine.
I know I’ve been banging on about this project a little lately, but I was pretty damn chuffed when it started working (it’s one of the most complicated pieces of code I’ve had the pleasure of putting together!).
Now, the full story has now gone up on the APC magazine website.
What’s cool about it… Read more

Software for the Arduino Enigma Cipher Machine

In the current August 2014 issue of APC Magazine, I’ve written about a functional-replica of an Enigma Cipher Machine that I’ve designed and built using an Arduino Uno microcontroller board.
But if you’re looking for the software, it’s on the APC magazine website but at in the August 2014 section.
Hopefully, it will be transferred to the regular Arduino page ( page shortly.
Sorry for the confusion.
The Arduino Enigma displays everything on a 16×2-LCD module shield and accepts… Read more

Turn an Arduino Uno into a digital audio recorder

One of the great things about Atmel’s ATMEGA328P microcontroller that powers the Arduino Uno boards is the sheer versatility of the chip. It might only clock in at 16MHz and process data in 8-bit chunks, but it has so many practical real-world interface options that helps it punch well above its weight.
My favourite part of the chip is the ADC or ‘analog to digital converter’. By rights, it’s only a 10-bit ADC and only has a rated sample rate… Read more