java - Posting updates to "a" wall -


i have facebook 'like' application - virtual white board multiple 'teams' share 'wall' common project. there 9-12 entities capture data. i'm trying have user's homepage display update of activities have happened since past login - how facebook posts notifications:

"[user] has done [some activity] on [some entity] - 20 minutes ago"

where [...] clickable links , activities (rather only) crud.

i'll have persist these updates. i'm using mysql backend db , thought of having update table per project store activities. seems there needs 1 trigger per table , redundant. more it's difficult nail down tabular schema update table since there many different entities.

the constraint use mysql i'm open other options of "how" achieve functionality.

any ideas?

ps: using jquery + rest + restlet + glassfish + mysql + java

it doesn't have handled @ database level. can have transaction logging service call in each operation. each transaction gets (unique, sequential) key.

store key of last item person saw, , show updates key higher, update last key seen.

a periodic routine can go through user accounts , see lowest seen transaction log key across users (i.e. newest log entry users have seen) , delete/archive entries key <= one.


Comments

Popular posts from this blog

python - Scipy curvefit RuntimeError:Optimal parameters not found: Number of calls to function has reached maxfev = 1000 -

c# - How to add a new treeview at the selected node? -

java - netbeans "Please wait - classpath scanning in progress..." -