If you are using PostgreSQL you can use this technique
-------- Original Message -------- Subject: Re: [Twisted-Python] Twisted and db table changes From: Mark Visser markv@lumierevfx.com Date: Tue, September 29, 2009 12:04 pm To: Twisted general discussion twisted-python@twistedmatrix.com
gary clark wrote:
Hello,
I have a server that needs to track changes on a table database.
When a table changes it needs the server accesses the table and send data out.
Not sure what the best approach to do this in twisted. Do I create a thread in twisted and monitor for any changes in a table or can I create a callback method to be triggered when a change occurs to table.
Check out twisted.internet.task.LoopingCall. It will run a callback periodically, during which you can poll for changes.
On Thu, Oct 1, 2009 at 4:27 PM, Steve steve@divillo.com wrote:
If you are using PostgreSQL you can use this technique
This is very interesting, thanks for sharing!
However, whenever I see a Twisted program calling select()... especially select() in a thread ;-) I wonder if things couldn't be made a bit simpler, responsive, and performant by just asking the Twisted main loop to monitor the file descriptor instead. It looks like "psycho pig two" has the functionality that you need.
(Are you planning to keep this technique described on the front of your website indefinitely? If not, a more durable link would be great :).)
-
Glyph Lefkowitz -
Steve