[nycphp-talk] Being notified when something changes in the database
papillion at gmail.com
Fri Aug 20 17:24:38 EDT 2010
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 atopia.net> wrote:
> 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?
>> Anthony Papillion
> New York PHP Users Group Community Talk Mailing List
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the talk