I've decided to implement real-time notifications into my app.
The notifications need to happen on certain events most of which would need to be triggered on updates to tables in the database.
To have it happen in real-time I'm currently using a free account with pusher and I'm willing to upgrade if and when the app scales.
However I'm pretty lost as to how to have Laravel 5 events trigger on updates to a table.
Currently I have triggers in the database that add records to a notifications
table when ever updates are made to certain tables. Ideally I'd have a Laravel 5 event fire whenever a record is added here and this would in turn use pusher to instantaneously send a notification.
Can anyone offer me direction or a good tutorial?
I essentially want clarity on where best to test that updates were successfully made to the database. Laravel events can be cast every time the ->save() method is called but in the case of notifications, that table updates based on database triggers so no code is relevant.