Have you ever needed to manage your remote MySQL databases, and ended up settling on the less-than-ideal setup of having an instance of phpMyAdmin on the same server as the MySQL server? Well, I am about to make your day. I am going to show you how to manage any number of remote MySQL databases from your local instance of phpMyAdmin; without compromising on security.

This tutorial assumes you've already got phpMyAdmin up and running locally. If you need help with that, there are plenty of articles floating around to guide you.

read more

Just like with any new skill, learning how to test takes time. For the longest time, I didn't do any automated testing. And, after trying my hand at test-driven development the last few months, I don't know what took me so long to get into it. I feel less stressed and more confident in the software I write. It takes time and discipline, but the benefits are well worth it.

Node.js has a lot of tools available for automated testing. Depending on what kind of testing you want to do, there is most likely already something available designed specifically for that purpose. In this post, I'll walk you through an example of unit testing and integration testing in Node.

read more

This is a short, to the point guide for anyone trying to get started with web development. This is not meant to be an exhaustive resource or to cover any particular topics in depth. Instead this is meant as a quick explanation of a few things to help total newbies get started.

read more

Inside Out

To think that humanity is here by some divine intervention; that the Universe was so devoid of purpose that it decided to create us to occupy it. Think of the hubris it takes to believe this mass-delusion. That's religion. And, that's nationalism. Sprung forth from the same watering hole; a bottomless well of ignorance and self congratulation. Good job. You're here. Like the rest of us.

read more

In this post I will walk you through the process of setting up a scheduled, automatic remote database backup on Linux.

read more

There are a number of use cases where by logging in via SSH (without a password) is the best (or maybe only) option. For example, if you wanted to run an automated backup on a remote server that would upload files to another remote server via scp, you would need SSH to work without a password. This post will guide you through the process of setting up passwordless SSH, such that you will be able to use scp and other utilities that rely upon SSH for authentication without having to use a password.

read more