Is there a design for a social network database?

Question

1 нояб. 2020 г. · A complete guide to designing a database in MySQL for social network system including users, friends, followers, groups, and messages. Profile: User detailsLast Login: It can be used to identify the last login of the userId: The unique id to identify the userEmail: The email of the user. It can be used for login and registration purposes

Best databases for building social network like appsPricePlatforms-- MySQLFree / paid--- OrientDB-Windows, Linux, Mac-- Neo4jFree / paidWindows, Linux, Mac-- RethinkDBFreeWindows, Linux, Mac

How do you design a database?

The design process consists of the following steps:1Determine the purpose of your database. ... 2Find and organize the information required. ... 3Divide the information into tables. ... 4Turn information items into columns. ... 5Specify primary keys. ... 6Set up the table relationships. ... 7Refine your design. ... 8Apply the normalization rules.Database design basics - Microsoft Support

What is Facebook's database architecture?

What Database Does Facebook Use? If you need a quick answer here it is: MySQL is the primary database used by Facebook for storing all the social data. They started with the InnoDB MySQL database engine and then wrote MyRocksDB, which was eventually used as the MySQL Database engine.

To be honest, I think the answer is no. MongoDB doesn't seem to fit really well with many-to-many relationships.

Expert · Answer