What’s the best manner of implementing a social activity stream? [closed]

by

I have created such system and I took this approach:

Database table with the following columns: id, userId, type, data, time.

  • userId is the user who generated the activity
  • type is the type of the activity (i.e. Wrote blog post, added photo, commented on user’s photo)
  • data is a serialized object with meta-data for the activity where you can put in whatever you want

This limits the searches/lookups, you can do in the feeds, to users, time and activity types, but in a facebook-type activity feed, this isn’t really limiting. And with correct indices on the table the lookups are fast.

With this design you would have to decide what metadata each type of event should require. For example a feed activity for a new photo could look something like this:

{id:1, userId:1, type:PHOTO, time:2008-10-15 12:00:00, data:{photoId:2089, photoName:A trip to the beach}}

You can see that, although the name of the photo most certainly is stored in some other table containing the photos, and I could retrieve the name from there, I will duplicate the name in the metadata field, because you don’t want to do any joins on other database tables if you want speed. And in order to display, say 200, different events from 50 different users, you need speed.

Then I have classes that extends a basic FeedActivity class for rendering the different types of activity entries. Grouping of events would be built in the rendering code as well, to keep away complexity from the database.

More Related Contents:

  1. ‘sudo gem install’ or ‘gem install’ and gem locations
  2. ActiveRecord: size vs count
  3. How to do a LIKE query in Arel and Rails?
  4. Multiple objects in a Rails form
  5. ActiveRecord Query Union
  6. Validate presence of one field or another (XOR)
  7. Altering the primary key in Rails to be a string
  8. Deprecated warning for Rails 4 has_many with order
  9. Rails 4 – passing variable to partial
  10. “gem install therubyracer -v ‘0.10.2’” on osx mavericks not installing
  11. How to get a query string from a URL in Rails
  12. How to spec a private method
  13. Rails: Can’t verify CSRF token authenticity when making a POST request
  14. Nokogiri ‘Failed to build gem native extension’ when I run bundle install
  15. Is there a way to access method arguments in Ruby?
  16. What is the use of Gemfile in rails?
  17. link_to :confirm displays popup twice
  18. How do you discover model attributes in Rails?
  19. Rails 3 equivalent for periodically_call_remote
  20. Convert HTML to word file ?
  21. 400 Bad Request – request header or cookie too large
  22. Ruby on Rails 3 – Reload lib directory for each request
  23. How to use long id in Rails applications?
  24. Rails: “Next post” and “Previous post” links in my show view, how to?
  25. How to configure Log4r with Rails 3.0.x?
  26. How do I extract Rails view helpers into a gem?
  27. Is puma the ONLY multi-threaded rails 4 http server?
  28. Rails devise: user_signed_in? not working
  29. ImageMagick – “CORE_RL_magick_.dll not found” or how to install RMagick on windows with ruby 1.9.2
  30. Rails Object Relationships and JSON Rendering

Leave a Comment