NYCPHP Meetup

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

Anthony Papillion papillion at gmail.com
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?

Anthony

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.
>
> -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
> http://lists.nyphp.org/mailman/listinfo/talk
>
> http://www.nyphp.org/Show-Participation
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20100820/e4784ded/attachment.html>


More information about the talk mailing list