database implementation for apps like instagram

database instagram implementation
anivader picture anivader · Jun 9, 2014 · Viewed 22.6k times · Source

I'm wondering how do apps like snapchat and instagram store pictures and user records in database.

Say I have a user table, how would they maintain list of followers for each user? Would they store the list of followers for each entry in user table or make a separate table for follow event and make an entry every time someone follows someone.

Also, for storing pictures, I'm guessing they would dump the pictures in a mass storage server space and store the URL in tables. Is there a better way of implementing this? If not, what kind of mass storage server would they go for? Dedicated or shared servers?

Thanks.

Answer

shazin picture shazin · Jun 9, 2014

You should read Instagram Engineering post at tumblr. This will let you know there technology stack.

And this will also help overall.

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More