Hi all I would like to develop some event notification functionality similar to the Facebook Notifications functionality.
Could anyone direct me to links relating to the architecture of such functionality or provide me with high level advice as to how to go about accomplishing this please? I have thought of an approach but am not sure whether this is the right way to go or not. Here is a high level overview: STEP 1: Collecting data: ------------------------ * Create a Trigger on every table you want to track / audit / follow * On Insert / Update to that table, add a record to the "Notifications" table which contains info relating to the changes. * You now have a notifications table containing data. STEP 2: Generating Notifications and displaying to user: -------------------------------------------------------- (not too sure about this approach but listed it anyway) * Subscribe the User to certain notification types * Either via schedule, or on User login, generate and save records to the "UserNotifications" table based on the notifications that the user is subscribed to in the "Notifications" table * Display these notifications to the user and marked as "read" once viewed. I'm sure there are many ways to skin this cat - but I am looking at the most efficient way possible in a high load environment. Any advice would be greatly appreciated. FYI: Railo3 and MySql 5 Thanks ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:333895 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
