Skip to content

Category Archives: Software

flickr!

I have grown tired of maintaining my gallery software locally (and lazy with uploading images..), so got myself a Pro Account and migrated all the existing images to the wonderful flickr. I will update the gallery link and tinker with blog integration - there are a few flickr widgets that might be just perfect [...]

aptitude love

A post to the debian-user mailing list included a nice little aptitude command to show installed packages not from the main debian apt repositories.
mshuler@ares:~$ aptitude search ‘~i!~Odebian’
i dynagen [...]

it wasn’t me..

My mail server is going mad.. It looks like some spammer decided to use my domain and I am currently rejecting thousands of emails to the user ‘fidpbandjellyqid’ at my domain.. Sorry, but it wasn’t me..

update: (Thu Jun 21 18:18:27) - the mail traffic is slowly but surely tapering off, but total [...]

epoch2local

Another little tidbit.. I use this frequently to translate epoch timestamps from a Postgres database log table:
#!/usr/bin/perl
# translate epoch time to human readable local time
use strict;
use warnings;
my $epoch = $ARGV[0];
if ( $epoch ) {
print “Epoch time: “.$epoch.”\n”;
print “Local time: “.localtime($epoch).”\n”;
} else {
print “This script takes an argument of [...]

psql2csv

CSV Output from ‘psql’ - courtesy of Will R.
#!/bin/bash
FS=”‘|field_separator|’”
RS=”‘|record_separator|’”
HOST=”localhost”
DB=”core”
USER=”core_write”
FILE=$1
psql -A -F$FS -R$RS -f$FILE -h$HOST -d$DB -U$USER \
| sed ’s/”/”"/g’ \
| sed “s/$FS/\”,\”/g” \
| sed “s/$RS/\”\n\”/g” \
| sed ‘1s/^\(.*\)$/”\1/’ \
| grep -v “^\”([0123456789]\+ row[s]\?)$”
This script will properly escape commas, quotes, and [...]

Valid XHTML YouTube Embedding

I was checking validation on my pages and found the only XHTML errors were from the suggested YouTube embedding code. A quick search revealed several XHTML valid code examples, and here is what I am using to center the frame under XHTML 1.0 Transitional (this fails 1.0 Strict validation - to make this validate [...]

Server Maintenance

The EIDE drive in my server died.. It had a grand life - 4-Oct-2004 to 3-Mar-2007 on Slackware 9.1 and only two reboots. I moved to Debian Etch for the OS - Slackware has been rock solid, but after swapping to Debian on other machines, the maintenance and software availability are just too [...]