...and Class::DBI may just end up doing all your work for you if you take to the poop approach.

wonderful, wonderful module. Well, modules: you do have to install a lot of the Schwern back catalogue. It has a few quirks, naturally, but an increasingly devoted following.

All you have to do is write a six or eight line subclass for each of your categories of object - in which you mention the names of the table, the columns and the key, and describe any relationships with other tables - and you have your application. Or a big part of it, at least.

It works particularly well sat between template toolkit and mysql, by the way, leaving a site designer able to hook objects directly out of the database at will.

sorry about the evangelical outburst.