How to get notified of changes on a read only table? (I.e., Price drop notifications.)
- by mirthlab
Let's say I have these tables/models:
Product
- id
- last_updated_date
- name
- price
User
- id
- name
Wishlist
- id
- user_id
- product_id
The Product table has a few million records and is being updated automatically each night via a data import (inserting into a new table, dropping the old one). I basically have read-only access to that…