Contents
You can choose between SQLite, MySQL, PostgreSQL, or NoSQL databases such as MongoDB. We recommend that you use MySQL or PostgreSQL for your social networking app. NoSQL databases aren’t designed to support many one-to-one and one-to-many entity relationships.
The most common database designs for social networking sites include quick reference functions, features for the addition and removal of social media sites and channels to your own database and the ability to filter sites based on multiple features. Almost 3 billion people use social networking sites regularly.
How do I create a Facebook database?
So, FB used its significant engineering might to essentially create a custom database query layer that abstracted the underlying sharded MySQL databases. In doing so, it forced its developers to completely give up on SQL as a flexible query API and adopt TAO’s custom NoSQL API.
What is a social database?
Social data is information that social media users publicly share, which includes metadata such as the user’s location, language spoken, biographical data, and/or shared links. Social data is valuable to marketers looking for customer insights that may increase sales or, in the case of a political campaign, win votes.
They have several different designs for various systems. This one is for a social networking site which may give you an idea of what’s required. You may want to search on SO for other social network database questions. I found this one that had a link to flickr showing a schema which appears to be from Facebook.
In this article, we will check out the first step in the design of a very basic social network: creating the database schema. A social network is a perfect use case for bottom-up design, since we can define security and required behaviors in a robust and scalable way.
What are the tables in a social networking site?
What are the Tables that would be present in a social networking site (ex: Twitter). I have a users table as of now. How to keep track of followers and people I do follow?
What’s the best way to use a social media database?
A good option for social media databases is buffering writes and caching for reads, to reduce read traffic to database. Buffering writes on the other hand helps to reduce the pressure on the database especially during peak times.