Notes ----- 1 - it is assumed that you have created a database, and populated table as described in the documentation supplied with this module. Scripts are here for this for Postgresql. 2 - if you have not, make test will fail, and that would make both of us look bad :-) 3 - if you want to run a test that differs from the supplied one, either in database connect string or the sql query used, then: a - edit the connect string in test.pl a1 - edit DBIx::Cache->connect with proper uname and password a2 - edit DBI->connect with proper uname and password b - move select.sql to select.old and copy your long sql statement into the file select.sql you may have to fool around with adding and remove carriage returns and whitespace as well as semicolons from this file to get it read in depending on your database driver c - thats it! Checking if your kit is complete... Looks good Writing Makefile for DBIx::Cache cp Cache.pm blib/lib/DBIx/Cache.pm cp i.pl blib/lib/DBIx/i.pl Manifying blib/man3/DBIx::Cache.3 PERL_DL_NONLAZY=1 /Users/cpanrun/pristine/5.8.7/bin/perl "-Iblib/lib" "-Iblib/arch" test.pl 1..2 Subroutine retrieve redefined at blib/lib/DBIx/Cache.pm line 204. ok 1 DBIx::Cache connect('dbname=mydb','postgres',...) failed: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? at test.pl line 30 DBI connect('dbname=mydb','postgres',...) failed: could not connect to server: No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"? at test.pl line 31 Benchmark: timing 1 iterations of t1_select_plain_dbi, t2_select_and_cache, t3_use_cached_query... Can't call method "prepare" on an undefined value at test.pl line 67. make: *** [test_dynamic] Error 255