Thursday, August 16, 2007
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 [...]
Wednesday, August 15, 2007
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 [...]
Also filed in
|
|
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 [...]
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 [...]
Also filed in
|
|
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 [...]
Also filed in
|
|
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 [...]
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 [...]