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.

Member Avatar for diafol

do you have any code so far?

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

Member Avatar for diafol

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 meeting, networking, learning, and sharing knowledge.