Warning: this reads the entire data set into memory, so be careful not to read huge amounts of data.

You can avoid this by creating other problems :)
Inside of get_hash(),

my $sth = $dbhandle->prepare( $stmt );
[download]

can become

my $sth = $dbhandle->prepare( $stmt, 
                              {"mysql_use_result" => 1} 
                             );
[download]

This will block other processes, and you will need to roll throught the complete dataset with fetchall_* or fetchrow_* and friends to avoid future errors on the handle unless you want to set up a brand new database for each query. It does seem to make sense some places, however.

  dug