SSH Shortcuts

Let's say that you have a server you SSH into very often. Let's also say that sshd on that server is running on a non-standard port to avoid annoying scanners (we'll using 53718 in this example). To SSH into this server, you run the following:

Read More...
Posted on 2011-10-19

Asynchronous MySQL Queries in Perl Using DBD::mysql and AnyEvent

A lot of people use MySQL, and these days, asynchronous-style programming has really taken off. If you're involved in both of these camps, you may be wondering how to send a query to MySQL and have it inform your event loop when it's ready with the results of that query. A common solution is to use a thread or child process for each connection, and exchange data using IPC. However, if you're using Perl and DBD-mysql 4.019 or better, you have an alternative: the new asynchronous interface.

Read More...
Posted on 2011-10-19

Repository-Specific Ignored Files in Git

Have you ever been working in a Git repository and wanted Git commands like git status to ignore certain files, but you didn't want to contaminate the project's .gitignore file with your specific ignore rules? Well, with .git/info/exclude, you can!

Read More...
Posted on 2011-10-19

Edit-Plackup-Test-Rinse-Repeat

At INOC, my place of work, I work on a lot of web applications with the backend written in Perl using Catalyst, and the frontend written in Javascript using ExtJS. With a UI written completely in Javascript, I often encounter bugs of the following form:

Read More...
Posted on 2011-10-17

Using Shared SSH Connections for a Snappy Netrw Experience

If you're a Vim user like me, you may know of a little plugin called netrw. For those of you who are not familiar with it, it's a plugin that allows you to transparently edit remote files from within Vim. Instead of scp'ing a file over, editing it, and scp'ing it back, you can just do something like this:

Read More...
Posted on 2011-09-16