Mysql - A developers delight
Updated May 07, 2024

Mysql - A developers delight

Alok Pabalkar | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with MySQL

As a RDBMS Transaction DB. We use it to store:-
1. User Profile
2. Transaction Data
3. Final Report related Data
4. Product Information
And Veriety of other information can be stored.

  • Provides different types of engines like MyISM, InnoDB, CSV etc (about 16 types) to store & read that information as per the requirement.
  • Storing Transaction Data because it is ACID Compliant
  • It is inbuilt functions for encryption, enciding, datetime operations, arithmetic operations, bin,hex,etc conversions, string operations etc
  • Very efficient in sorting, aggregations, full-text, partial-text searching
  • Should have a Column Based storage engine for a analytical & reporting data.
  • Can have a improved document storage
  • MySQL doesn't have many tools to monitor performance and fix issues easily
  • Mysql is an excellent choice of DB and has a use case in almost all kinds of projects
  • It is a easy to use, maintain and build applications. It saves cost and can work of bare minimum infra. Can be scaled as the project grows
  • Data migration and operations is simple. It can form the backbone of any project and store and read/write all kind of information. As the project grows the stored information can be easy migrated to different databases
SQLite - Is the goto DB for Mobile/Desktop Apps. Its not as elaborate as Mysql but since its a RDBMS it provides all the basic features and its lite. We use mysql at the backend and for desktop app we use SQLite

postgres - Its a formidable opponent. It is fast and reliable and is is an object-relational database. It is more suited for very complex processing as it has a very tight data integrity. For simple, read-heavy workflows, web based projects (almost all projects) mysql is a much better choice. Also writing and executing query on mysql based client is a easy job. Personally I find executing queries on PSQL terminal quite cumbersome.

Do you think MySQL delivers good value for the price?


Are you happy with MySQL's feature set?


Did MySQL live up to sales and marketing promises?


Did implementation of MySQL go as expected?


Would you buy MySQL again?


Mysql is Fantastic for:-
1. User Management
2. Transactional Data
3. Final Reporting Data as it can be very quickly accessed and displayed on graphs

Not to be used for:-- It cannot be horizontally scaled so not suitable for very high data volumes- Should not be used for storing unstructured data- Should not be used real-time analytics, content management, document intensive storage