• INSTALLATION AND USAGE INSTRUCTIONS

INSTALLATION AND USAGE INSTRUCTIONS

• Install SQL::Catalog
  

   perl Makefile.PL
   make
   make test
   make install

  You will need to download and install SQL::Statement and DBIx::AnyDBD unless you are using CPAN.pm which will detect them as a prereq and install them for you.

  The Makefile.PL will create a configuration file in lib/SQL/Catalog/Config.pm which SQL::Catalog will use to create the tables sql_catalog, sql_catalog_ft and later to connect to the database and register SQL in these tables.

  You must set the following environmental variable to the name of your DBD driver sans DBD::, e.g.:

   setenv SQL_CATALOG_DSN Pg

  If you want to use the cache and spider methods, then you have to configure the SQL::Catalog Cache::Cache, e.g:

   setenv SQL_CATALOG_STO Cache::FileCache 
   setenv SQL_CATALOG_OPT "namespace => 'sql_catalog', default_expires_in => 600"

• Copy the sql_* scripts to a place on your $PATH
  
• Let 'er rip.
  
• SQL::Catalog should work for any SQL-92 compliant database
  but has only been tested on Postgresql