Item: MySQL
Rating: 8
Author: Nikita kumari

Overall Satisfaction with MySQL

Use Cases and Deployment Scope

We store customer query data into a MySQL database, as we keep the record of every user into our database so it is easy to check the status of their queries.

Pros and Cons

Pros

Easy to add joins on tables.
Easy to keep records of every user.
Protection from an unauthorised user as we have to provide a valid username and password while logging into SQL DB.

Cons

It should create indexes automatically if a table has a large amount of data.
It should add a feature so that we can restrict access to a particular table from a database.
Need improvement in query performance.

Return on Investment

Increased the productivity of business.
Easy to handle client queries.
Storing customers credentials into DB.

Alternatives Considered

MongoDB and Azure SQL Database

As MongoDB does not support relational queries we have to write all queries manually, but My Sql supports this feature through joins.

Other Software Used

MongoDB, Azure SQL Database, Google Cloud AI

Likelihood to Recommend

If we have complex or dependency data we always prefer to use MySQL as it provides an RDBMS feature. If we have a larger amount of data it does not give a better performance.

Comments

Please log in to join the conversation

Easy to store relational data.