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
Post a Comment