[nycphp-talk] Being notified when something changes in the database

Matt Juszczak matt at
Fri Aug 20 17:22:28 EDT 2010

Use triggers, plus a queue, and have a script watch that queue.


On Fri, 20 Aug 2010, Anthony Papillion wrote:

> So I'm developing an application that will work within a larger supply chain system. There is a table in the database
> called 'Items' which holds a list of all items and how many of those items are in stock at a particular location.  Fairly
> regularly, another system will change that table (for example, when a new shipment of items come in) and I need to
> notified of that change and fire a script to process those changes.
> How can this be done effectively and reliably?  Is there a 'standard' way of doing it?
> Thanks!
> Anthony Papillion

More information about the talk mailing list