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

Anthony Papillion papillion at
Fri Aug 20 17:24:38 EDT 2010

Hi Matt,

I get the use of triggers but can you explain the queue concept? Let's say I
want to be notified every time the count of an item is increased. How would
a queue play into that?


On Fri, Aug 20, 2010 at 4:22 PM, Matt Juszczak <matt at> wrote:

> Use triggers, plus a queue, and have a script watch that queue.
> -Matt
> 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
> _______________________________________________
> New York PHP Users Group Community Talk Mailing List
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <>

More information about the talk mailing list