in reply to PostgreSQL web application examples?

While not being directly applicable to your question (it's not an example per say), allow me to recommend using Class::DBI to manage your tables.

It wraps a thin OO layer around your tables, allowing you to not have to write the trivial insert / update statements that are the oh-so-boring side of DB development.

As far as the web generation side of it goes, I have had good success with HTML::Mason

Replies are listed 'Best First'.
Re^2: PostgreSQL web application examples?
by halley (Prior) on Feb 22, 2005 at 14:31 UTC
    Holy cow, I am happy to find Class::DBI! I was thinking last night how I could somehow make a generic schema layer that would translate record-to-object, and I was hoping there would be something already like it. This module goes a bit beyond what I was imagining, which is a relief to me. I should not get TOO hooked on it, because I do want to learn the underlying SQL methodology, but this looks like it'll take tons of drudgery out of Perl apps.

    I also want to mention a link I found shortly after digging into Class::DBI. I found a script someone wrote to output an Entity Relation Diagram (ERD): http://www.adp-gmbh.ch/perl/erd.html

    --
    [ e d @ h a l l e y . c c ]