Mysql - A developers delight
July 06, 2022
Mysql - A developers delight
Score 10 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.
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
- PostgreSQL and SQLite
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.
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?
Yes
Are you happy with MySQL's feature set?
Yes
Did MySQL live up to sales and marketing promises?
Yes
Did implementation of MySQL go as expected?
Yes
Would you buy MySQL again?
Yes