I have a project im working on that includes an activity stream.

I'm working in php and MongoDb (noSql).

The site can post articles, users can promote articles or add them to favorites.

How may i include these in an activity stream similar to facebook or twitter?

Example:

Josh, john, and jane just "promoted" this article.

______________

how should i create my database to be able to do this easily?

Josh, john, and jane and my friends and i would see this in my profile on my activity stream.

Recommended Answers

do you have any code so far?

Jump to Post

All 3 Replies

Member Avatar

do you have any code so far?

No, I'm mostly looking for database design, Code wouldn't be that hard.

Member Avatar

Never used mongoDB but if it's a table structure you want. Probably something like this:

vote_id (autoincrement, optional)
item_id (= item being promoted)
user_id
taste (1 = like, 0 = dislike)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.