Databases
StackOverflow2013
Postsdbo
POFacebook newsfeed in mysql
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POFacebook newsfeed in mysql
    primarykey
    data
    text
    <p>I want to create a Facebook like newsfeed for my users that basically does the following</p> <ul> <li>it keeps track of the activities of users and their friends</li> <li>users can see recent friend activities on their newsfeed</li> </ul> <p>but i am not quite sure how best to implement this in mysql. Like what sort of tables will I need? What is the structure of these tables? What will I store in these tables? How will I keep track of user and friends activities. I want to build an efficient system that will scale up. I prefer working with PHP and Mysql if possible!</p> <p>I was thinking of having a NEWSFEED table and when a user does something (posts a comment, etc), I add an entry to that table for the user's friends and the user himself that will show up on their newsfeed. </p> <p>The table structure would be as follows</p> <pre><code>uid INT activity ENUM activity_id INT </code></pre> <p>So let's say I have a comments table with the following structure:</p> <pre><code>title VARCHAR(255) message TEXT </code></pre> <p>If the user posts to that table and an entry with ID=5 gets created for that user, then the following entry will be added to the NEWSFEED table</p> <p>uid=3 activity="comment" activity_id=5</p> <p>that means that to display the newsfeed for each user, I would have to do the following:</p> <p>SELECT * FROM newsfeed WHERE UID = ....</p> <pre><code>FOR EVERY ROW: CHECK activity type (if activity == 'comment') **QUERY the corresponding table and display the result (so I would query the comments table an display the person's comment)** </code></pre> <p>I am thinking of deleting entries more than >3 months old to prevent the table from getting too huge. But I don't like that I am doing independent queries to display for each activity type (just as I did above where I queried the COMMENTS table to display the comment whose ID is mentioned in the NEWSFEED table).</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USBrown Limie
    1. USBrown Limie
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COare you asking us to program this for you? This is way too broad a question. It sounds like you need to do some database tutorials and come back when and if you get stuck with something specific.
      singulars
      1. POFacebook newsfeed in mysql
      1. USSteve
    2. COno I would like some help with the design, if that is possible. not the coding.
      singulars
      1. POFacebook newsfeed in mysql
      1. USBrown Limie
    3. COa table of people, a table of feeds, a lookup table of friends i.e. people matched to other people could do it. A page would then search for all your friends and their associated feeds. Wanting details like "what would I store in these tables" comes under learning database design. You will make mistakes but that's how you learn. TO be honest, if you are new to this sort of thing, you likely need someone who is expert in scalability otherwise down the rack you are going to slap your forehead numerous times...trust me, I have the bruises.
      singulars
      1. POFacebook newsfeed in mysql
      1. USSteve
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload