database Instagram 等应用程序的数据库实现

database implementation for apps like instagram

提问by anivader

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

我想知道 snapchat 和 instagram 等应用程序如何在数据库中存储图片和用户记录。

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?

此外，为了存储图片，我猜他们会将图片转储到大容量存储服务器空间并将 URL 存储在表格中。有没有更好的方法来实现这个？如果没有，他们会选择什么样的大容量存储服务器？专用服务器还是共享服务器？

Thanks.

谢谢。

采纳答案by shazin

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

您应该阅读tumblr上的 Instagram 工程帖子。这会让你知道那里的技术堆栈。

And thiswill also help overall.

而这也将有助于整体。