CODEWITHSUNDEEP
mysqlsqlgoogle-app-enginenosql
Ryan Murphy
Ryan Murphy

Reputation: 163

Sql vs nosql for a realtime messaging app?

I am creating a messaging app. I have my users stored in a mysql database and messages stored in google datastore a nosql database. However I was wondering what would be the drawbacks of having my messages in a mysql database since I am fetching the message and the user simultaneously.

Is there performance drawbacks?

Upvotes: 1

Views: 1334

Answers (1)

RTE
RTE

Reputation: 75

Generally, different database usage cannot affect anything if your backend architecture is well-defined. Database stores only data to manipulate. I think for authentication you use mySQL and store data in Google Datastore. Performance drawbacks are coming from the bandwidth of your server.

I propose that you must use the same database to store all data, it will be more stable and easy to manage.

Upvotes: 2

Related Questions