How are databases used in social media?

Question

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. 4 июн. 2018 г.

It does make sense that using a graph database is the best option, better than a simple RDBMS/conventional NoSQL. MongoDB for document storage, and using mongo-connector in collaboration with neo4j for storing relationships, likes and stuff.

What can databases be used for?

Databases are used for storing, maintaining and accessing any sort of data. They collect information on people, places or things. That information is gathered in one place so that it can be observed and analyzed. Databases can be thought of as an organized collection of information.

What databases does Instagram use?

Storage. Instagram mainly uses two backend database systems: PostgreSQL and Cassandra. Both PostgreSQL and Cassandra have mature replication frameworks that work well as a globally consistent data store. Global data neatly maps to data stored in these servers.

You don't have to worry about the amount of data, MySQL can easily handle the data for 10,000 users. I would say use a database you are familiar with. PostGreSql has some few advantages, but MySQL has its own perks too.

Expert · Answer