Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: Log changes in a database (DBI)

by Corion (Patriarch)
on May 03, 2011 at 10:51 UTC ( [id://902673]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?

www.com | www.net | www.org
Node Status?
node history
Node Type: note [id://902673]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? • Last hour • Other CB clients
Other Users?
Others romping around the Monastery: (7)
As of 2024-04-18 06:37 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found