Chad Clark's Open Journal : 2007-12-19

1) Postgres Christmas carol.

Someone sent this my way.  I don't know who wrote it.  I was told it
requires postgresql 8.  I ran it on 8.2.4.

  select v || case
  when v=1 then ' partridge in a pear tree'
  when v=2 then ' turtle doves'
  when v=3 then ' french hens'
  when v=4 then ' calling birds'
  when v=5 then ' GO-O-OLDEN RINGS!'
  when v=6 then ' swans a swimming'
  when v=7 then ' geese a laying'
  when v=8 then ' maids a milking'
  when v=9 then ' ladies dancing'
  when v=10 then ' lords a leaping'
  when v=11 then ' pipers piping'
  when v=12 then ' drummers drumming'
  end from
  (select generate_series(generate_series(1,12), 1, -1) as v) q;


2) Perl version 5.10 has been released.

http://dev.perl.org/perl5/news/2007/perl-5.10.0.html reads:

  The new smart match operator implements a new kind of comparison, the
  specifics of which are contextual based on the inputs to the
  operator. The result is that all comparisons now just Do The Right Thing
  
  ...
  
  Other improvements include state variables that allow variables to
  persist between calls to subroutines
  
  ...
  
  The Perl interpreter itself is faster with a smaller memory footprint
  
  ...
  
  threading improvements.

3) Marking eBay item locations on a map.

I created a tool using eBay and Google Maps to search for items up for
auction and mark their locations on a map.

Try out the eBay item locator.  Clicking on a marker bring up the item
description.  Clicking on a description opens the auction page on eBay
in a new window.