NYCPHP Meetup

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

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


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
> 
>


More information about the talk mailing list