Table: preferences
  +----+------------------+----------------------------+
  | id | name             | value                      |
  +----+------------------+----------------------------+
  |  0 | filename         | /path/to/file.txt          |
  |  1 | item_enabled     | 1                          |
  |  2 | task_name        | something                  |
  +----+------------------+----------------------------+
[download]

  print DB::Prefs->filename,$/;
  DB::Prefs->filename("/new/path/to/file");
[download]

  my $row=DB::Prefs->search({ name => "filename" })->first;
  print $row->value,$/;
  $row->value("/new/path/to/file");
[download]

A MySQL query sniffer. It sniffs the network with Net::Pcap, extracts queries from MySQL packets, and prints them on standard output.

The documentation, as well as any future versions, lives at [http://iank.org/querysniffer/]

A counterpart to part, it allows you to join two files side by side according to common values. This is similar to the join UNIX command except that the join command expects the input files to be sorted according to the keys, while this program will slurp the second file into a hash and then output the result according to the order of the first file.

Optionally (and untested) it can use a tied hash as on-disk storage in the case that the storage for the files is larger than the available RAM.

In big compagnies, access to ftp are reduced so that cpan install ... can't be used easily because it used principaly ftp as module download protocol.

This script is a mix between shell and perl.

This script is based in wget, tar from the system so that you don't need extra modules to start installing automatically new module.

In fact, this is a nasty way, to be honest but it can be used to install cpan, libwww, cpan2rpm and them it can be forgotten.

But for a brand new installed system it is a ideal module installer because it is not depending from various module but from a standard based install perl !

In order to cross proxy just set your http_proxy environnement variable.

export http_proxy=proxyIp:proxyPort
perl cpan.pl cpan2rpm
[download]