Which database is best for social media app?

Question

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. 30 авг. 2014 г.

MongoDB has evolved as a new form of database which can be used by the developers. The reason why one should use MongoDB for Social Networking Websites are document oriented storage, indexes on any attribute, Replication and High Availability, Auto Sharding, Rich Queries, Fast in-place updates.

Which database is best for apps?

PostgreSQL. A unique relational database, PostgreSQL is the best database for Android and iOS apps. Developers can customize this database as they want; that's why it's the most preferred mobile app database.

What kind of database does Instagram use?

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.

As a result, MySQL would be the better recommendation because it will have the data reliability and relational tools necessary to handle the interactions and relationships among numerous users. You may also decide to use both MySQL and MongDB together to utilize the best features of each database.

Expert · Answer