The Author – Bart Busschots
Creative Commons
Unless otherwise stated, the content on this site is licensed under Creative Commons Attribution, Noncommercial, No Derivative Works 3.0 License
May
26
TTT Part 4 of n – Navigation
Filed Under System Administration, Computers & Tech on May 26, 2013 | 4 Comments
In the previous segment we discussed the concept of a file system in detail. We described how filesystems contain folders which contain files or folders, and we described the different ways in which Windows and Linux/Unix/OS X combine all the filesystems on our computers into a single name-space, within which every file has a unique ‘path’ (F:\myFolder\myFile.txt -v- /Volumes/myThumbDrive/myFolder/myFile.txt). In this instalment we’ll look at how to navigate around the Unix/Linux/OS X filesystem in a Bash command shell.
May
24
Converting Unix Time Stamps to SQL Dates (ISO 8601) with Perl
Filed Under Software Development, Computers & Tech on May 24, 2013 | Leave a Comment
I spent quite some time this afternoon finding a reliable way of converting Unix Time Stamps (UTS) to the ISO 8601 format used in SQL databases like MySQL and PostgreSQL that does not get confused by timezones. In the end the final result is, as is so often the case with Perl, very short and simple, but since the Googles failed to find the answer for me today, I thought it would be worth sharing in case it’s of use to others in the future.
use DateTime;
# Function to convert Unix Time Stamp to ISO 8601 Date
# Arguments:
# 1) The Unix Time Stamp to convert
sub uts_to_iso8601{
my $uts = shift;
my $date = DateTime->from_epoch(epoch => $uts, time_zone => 'UTC');
return $date->ymd().q{ }.$date->hms().'z';
}
The algorithm is very simple, use DateTime‘s from_epoch function to a DateTime object in the UTC timezone (AKA Zulu). Then assemble the output as YYYY-MM-DD HH:MM:SS, and append a z for Zulu. MySQL and PostgreSQL can now use the string to populate Date or Timestamp columns.
As an example, the Unix Time Stamp 1369410796 converts to 2013-05-24 15:53:16z.
May
18
Thanks Tim
Filed Under My Projects, Computers & Tech on May 18, 2013 | 5 Comments
This is not going to be an easy post to write, and I really hope I do it justice.
The Apple/Mac community lost one of it’s finest podcasters today. Tim Verpoorten wasn’t the first Apple/Mac podcaster, but he was one of the very earliest generation. I think it would be fair to call him a father figure to many of us who followed. I know he was one of the podcasters who inspired me to pick up the microphone myself, and I doubt I’m alone in that.
Tim had been unwell for some time, and hung up his microphone to concentrate on his health a while ago, but we all hoped it would just be a temporary hiatus. I don’t think any of us in the community wanted to believe we’d heard the last of Tim’s distinctive and friendly voice.
Every good Apple/Mac podcast brings something unique to the table, and Tim’s Mac Review Cast brought fantastic reviews week after week after week for years and years. Tim had a knack for finding great apps, particularly free ones, and he was able to find and review them at a truly impressive rate. Most people can mange either quantity or quality, but Tim could do both at the same time. Although he reviewed many many apps, you could always tell when an app really appealed to him. Those apps were almost never large apps with lots of features, but small apps that did just one thing, but did it really well. It’s fair to say Tim had a bit of a thing for menubar apps.
Because I learned about so many great apps on the Mac Review Cast, I regularly look up at my menu bar, or into my dock, and think of Tim. One app in particular that I’ll always associate with him is the light-weight Mac-like text editor Smultron. I’d almost given up on finding an editor like this for the Mac, when I heard Tim review Smultron, and gave it a go. It was love at first sight, and that cute red strawberry icon will always bring back fond memories of Tim.
Tim was one of the founders of the Mac Round Table Podcast (MRT), and it was through that podcast that I was fortunate enough to get to ‘work’ (play more like) with Tim. One of the great things about the MRT is how different all the contributors are, and how that opens up some great conversations. We often agreed on things, but when it comes to temperament, I think myself and Tim were polar opposites – I’m know for being the cranky Irishman (sorta) who’s prone to impassioned (and hopefully entertaining) rants, while Tim was always as cool as a cucumber – I can’t remember him ever getting flapped, and I can’t remember him ever having a bad word to say about anyone. I think it’s much easier to go on a rant than it is to remain calm and collected, and I greatly admired Tim’s coolness.
I never met Tim in the real world, yet I feel I’ve lost a friend. The Mac community has certainly lost one of it’s finest ambassadors, but my thoughts are with the Verpoorten family tonight – their loss is so much greater than ours.
The photo that accompanies this post is a crop from this image by Allison Sheridan.
May
11
TTT Part 3 of n – File Systems
Filed Under System Administration, Computers & Tech on May 11, 2013 | 3 Comments
This is the third instalment of an on-going series. These blog posts are only part of the series, they are actually the side-show, being effectively just my show notes for discussions with Allison Sheridan on my bi-weekly Chit Chat Across the Pond segment on her show, the NosillaCast Mac Podcast. This instalment will be featured in NosillaCast episode 418 (scheduled for release late on Sunday the 12th of May 2013).
In the first installment we started with the 40,000ft view, looking at what command shells are, and why they’re still relevant in today’s GUI-dominated world. In the second instalment we looked at OS X’s Terminal.app, the anatomy of the Bash command prompt, and the anatomy of a Unix/Linux command. This time we’ll be looking at the anatomy of file systems in general, and the Unix/Linux file system in particular, and how it differs from the Windows/DOS file system many of us grew up using.
May
5
The Royal Canal Shuttles
Filed Under Photography on May 5, 2013 | Leave a Comment
Exactly two weeks ago today (on the 21st of April 2013) the Railway Preservation Society of Ireland (RPSI) ran two steam specials from Dublin to Maynooth and back which they named Royal Canal Shuttles. The name was inspired by the fact that the section of the Sligo line between Dublin and Maynooth runs along the banks of the Royal Canal for almost its entire length.
The trains consisted of the RPSI Cravens coaches, and were worked by the RPSI’s 0-6-0 steam loco No.186. The trains were a little more special because No.186’s boiler certificate will expire later this year, so this could well have been the last time she’ll be on this line for a decade or more. Once her certificate expires she’ll have to be fully overhauled, and given that the RPSI is a volunteer group, that will take quite some time. No.186 has proven herself to be a remarkably reliable engine over the last few years, and I’ll certainly miss seeing her around.
The weather forecast for the day was awful, but thankfully it turned out to be a little too pessimistic.