Welcome to the DBIx::Tree module. This modules lets you turn things like:

    food                food_id   parent_id
    ==================  =======   =========
    Food                001       NULL
    Beans and Nuts      002       001
    Beans               003       002
    Nuts                004       002
    Black Beans         005       003
    Pecans              006       004
    Kidney Beans        007       003
    Red Kidney Beans    008       007
    Black Kidney Beans  009       007
    Dairy               010       001
    Beverages           011       010
    Whole Milk          012       011
    Skim Milk           013       011
    Cheeses             014       010
    Cheddar             015       014
    Stilton             016       014
    Swiss               017       014
    Gouda               018       014
    Muenster            019       014
    Coffee Milk         020       011

into:

    Food (001)
      Dairy (010)
        Beverages (011)
          Coffee Milk (020)
          Whole Milk (012)
          Skim Milk (013)
        Cheeses (014)
          Cheddar (015)
          Stilton (016)
          Swiss (017)
          Gouda (018)
          Muenster (019)
      Beans and Nuts (002)
        Beans (003)
          Black Beans (005)
          Kidney Beans (007)
            Red Kidney Beans (008)
            Black Kidney Beans (009)
        Nuts (004)
          Pecans (006)

There are a couple of examples in the examples/ directory.

To build this, do the following (Unix and Unix-like systems):

   perl Makefile.PL
   make
   make test
   make install

or (Win32 with MS Visual C++):

   perl Makefile.PL
   nmake
   nmake test
   nmake install

When you tell a user id and password to the configuration portion of 
Makefile.PL, be aware that this is being stored in a file called PWD. 
It is recommended that you only choose a user id and password on a
non-production server, since this module will drop and create a table
in that data source (the food table).

As of this version, this has only been tested on:

  Windows NT 4.0 SP3, ActivePerl 502, DBD::Sybase
  Sparc/Linux 2.0.35, Perl 5.004_04, DBD::mSQL
  RedHat Linux 6.1, Perl 5.005_04, DBD::mSQL
  Mac OS X, Perl 5.6.0, Mac OS X 10.2.4

Brian Jepson, bjepson@jepstone.net
Sourceforge Project Page: http://sourceforge.net/projects/dbix-tree/