Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Tailing a database table via DBI

by TheHobbit (Pilgrim)
on Apr 21, 2002 at 17:14 UTC ( [id://160899]=note: print w/replies, xml ) Need Help??


in reply to Tailing a database table via DBI

Hi,
I do not think this would be possible. Infact, the DBI module connects to the Mysql server as a client. It is then impossible for the server to signal the client that something has changed. This would even be contrary to the basic philosophy of Client-Server paradigm.

I do not know for mysql, but in postgresql you can add triggers, and even write them in Perl; then again you have to have access to the database structure...

Cheers
Leo TheHobbit
GED/CS d? s-:++ a+ C++ UL+++ P+++>+++++ E+ W++ N+ o K? !w O? M V PS+++
PE-- Y+ PPG+ t++ 5? X-- R+ tv+ b+++ DI? D G++ e*(++++) h r++ y+++(*)

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://160899]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others meditating upon the Monastery: (4)
As of 2024-03-29 10:10 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found