Colin Robinson

Programming

Use MariaDB with PhpStorm

Update August 2018: PHPStorm now includes MariaDB as a schema type but does not include the driver files. It does offer to download the MariaDB driver for you, but if you want to use the native driver, install mariadb-jdbc from the AUR and edit the MariaDB entry in PHPStorm to use /usr/share/java/mariadb-jdbc/mariadb-java-client.jar as the driver […]

Quickly reload a database

I’m mostly posting this to copy/paste when I forget, but it’s useful information nonetheless so lets have at it. Delete the database Create a new database Import SQL file into the new database Assume the mysql user/pass combo is colin/mypassword and the database is called db123. mysqladmin -u colin -pmypassword drop db123; mysqladmin -u colin […]

Github and code review

I first wrote a post in March 2012 about code review with SVN. Since then, we’ve switched to Github and it’s awesome. Github isn’t free, buts its very inexpensive and amazing. Inline comments, automatic issue tracking, and you can backup your code to their servers without needing commit access to the main repo.

IPv6 Subnet Calculator

I wrote a tool to organize subnet addressing for IPv6 Demo | Source Code A little about IPv6 An IPv6 address is 128-bits and commonly represented as eight colon separated groups with each group consisting of four hexadecimal digits. For the general unicast address format, the first 64-bits are used for routing and the second 64-bits are the interface identifier […]

iPad and iPhone Web Frameworks

Sencha Touch This is the gold standard of iPad web frameworks. It’s amazing (and free!), check out the kitchen sink demo. Project Page

Code Review

Where I work, we have a lot of new developers and people still learning the languages. When learning a language, being able to get feedback on your code is an invaluable learning asset. It lets the more experienced programmers help teach the newer ones. Most code review software is designed for pre-commit comments. A reviewer looks at the code […]

How do you measure productivity?

How do you measure your productivity while writing code? Judging a program’s success by lines of code (LOC) is like judging how successful an airplane is by its weight. Consider a more modern approach from Agile development called Weighted Micro Function Points.

Quick CSS3 Fade Effect

Very simple fade effect for images that uses only CSS. .box_transition { -webkit-transition: all 0.3s ease-out; /* Saf3.2+, Chrome */ -moz-transition: all 0.3s ease-out; /* FF4+ */ -ms-transition: all 0.3s ease-out; /* IE10? */ -o-transition: all 0.3s ease-out; /* Opera 10.5+ */ transition: all 0.3s ease-out; } Demo

LESS: The dynamic stylesheet language

Wow, just wow. Imagine if you could use variables in CSS… now you can. Here is the LESS website. The proposed method of using LESS is to write a style.less file and then include less.js which uses javascript to render your stylesheet dynamically. I really don’t like the idea of having to load an extra […]