Loop wiring at home
I always struggle with this. Too many red and black cables and never sure where to put them. But here…
Finding text in files in a folder
Quite often I find myself looking for files which contain the same text. Mainly config settings, etc. On linux you…
Calculation for working out overage
If you are trying to mathematically calculate the percentage that something was overbooked then this calculation will work: 100 x…
Auto-complete Lists in HTML5
Jquery is everywhere, its good. People like it. Its easy(ish) for beginners to create great web apps. It’s also large,…
HTML5 Boilerplate
Annoying to find, so a quick easy to find snippet here <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <title>New…
MySQL / MariaDB Superuser
Simple syntax to create a super user (for editing users and dropping schemas etc) CREATE USER 'superuser'@'%' IDENTIFIED BY '[password]';…
MySQL Relative Time Since
You have some data which many users edit often, and you want to return a field with some sort of…
MacOS Compact VDI file
In order to compact a virtualbox VDI file and recover some of the lost space (especially useful when using a…
OpenVPN keeps disconnecting with an inactivity timeout
I’ve used openvpn on Mac (using Tunnelblick) for a few years for a home->work VPN connection with no issues, and…
Posting Slack message on Google Docs spreadsheet cell update
We’ve been using a bit of a google doc recently for logging stuff, and sometimes cells get missed. I wanted…