While I can recommend Class::DBI::Loader, I can only discourage people from using Class::DBI::Loader::Relationship, which I consider underdocumented and over-hyped. It is/was nice and convincing for Simons live demonstration of how to create a web frontend for a database in under 20 lines of code, but using english as a configuration language for your relationships is really error prone. The error messages or diagnostics (not) output by cdbi:l:r don't help either, and unless you have taken a long look at the source code, it's not easy to modify the examples to suit your actual situation. A more formal syntax would help here and remove the heavy dependency on a good and judicous choice of words made by the program author while still preserving the wanted clarity.

The module relies on the very simple-minded yet totally undocumented assumption that all phrases will be of the form single-noun verb (a|many) noun - once you glean this from the source code, you can start using it, but the time is better invested in some less magic method of setting things up.

Adding to the situation is, that the module is not maintained anymore, and if I stepped up as maintainer of it, I would mainly depreciate the use of the module and replace it by something with a more formal syntax:

  brewery 1:n beer            # "a brewery produces many beers"
  beer m:n(handpump) pub      # "a pub has beers on handpumps"
[download]