Hi,

Our marketing group makes changes to a fairly simple table (5 cols) in a postgres db via a cgi.

In a nutshell I want to disaply an html history of who made what changes to the table content, and am wondering if there's some module out there I can leverage for this.

I need to show more than, Bob made some changes on date X, I need to show, Bob deleted this, added this, modified this. etc.

Later I'd actually like to implement this on more than one cgi, that changes content.

Anything come to mind that could be tasked for this, or a simple way to do this?

I feel like there must be somethign already that I don't know about.

thank you!
Lin

In reply to Tracking changes to a db table by luinalin

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.