in reply to Log changes in a database (DBI)

If you were not using MySQL, using database triggers would be a possible approach. I think that MySQL has triggers, starting with 5.0, but I've never used them.

For SQLite (and SQL triggers, in general), there is this post for example.

Updated in response to tinitas comment.

Replies are listed 'Best First'.
Re^2: Log changes in a database (DBI)
by tinita (Parson) on May 03, 2011 at 13:39 UTC
    so you're basically saying that you think mysql has triggers (it has, I have been using mysql triggers at least 5-6 years ago), but still say that triggers are only a possible approach if the OP was not using mysql?
[reply]

      Ooops - I first wrote my text thinking MySQL still lacked triggers, but then searched for trigger documentation and found that MySQL 5 has triggers :-/

[reply]
[d/l]

In Section Seekers of Perl Wisdom