MySQL - Possibly the only database you will ever need
December 28, 2018

MySQL - Possibly the only database you will ever need

Joel Tanzi | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with MySQL

I primarily use MySQL for data storage for content-management systems for websites built in Drupal or WordPress. It provides a simple, easily-managed solution to the need for performant data storage and querying for site data, such as pages or posts. I also use it as the back-end data storage and querying solution for static front-end web applications built in Angular, React or Vue. It remains my go-to choice when I need an SQL database for my applications and/or CMS. My business is a small one so it is used only by myself, and therefore across my organization. I use the Community Server edition as it suits my needs without having to extend it to the Enterprise Server edition.
  • The Community Server edition remains a strong candidate for a SQL-based database solution that supports a wide array of data structures.
  • It scales well for both small business and enterprise use.
  • It performs very well provided your database schema is well-planned and carefully considered (which is the case for any database solution).
  • It has a number of interface solutions including GUI-based ones such as phpMyAdmin and MySQL Workbench that allow for easy management of your databases.
  • Does not fully comply with SQL standards, most notably in regards to referencing foreign keys.
  • A major bug remains in its implementation of timestamp methods that will result in a 0 being returned for dates falling after Jan 19, 2038. While possibly not a show-stopper for most use cases, there are applications where date ranges that far out will be required (such as loan management).
  • Its open-source nature may not suit larger organization or high-performing systems well, which may benefit from the stronger support and scalability of premium products.
  • It has made site management through a CMS like WordPress or Drupal infinitely easier to manage.
  • It is a critical part of the LAMP, WAMP and MAMP stack and has been a major driver of innovation in the content-management-system space, pushing site and web-application development toward greater democratization.
  • It has proved to be very reliable and easy to set up and administer and saves me tremendous time troubleshooting query and performance issues.
It would be hard to make a case for the use of Microsoft Access for any but the most simple of internal business applications at this stage, not because it is a bad product but it falls well short of the power and scalability of MySQL and almost any other databse solution out there.

MongoDB is a strong competitor to MySQL but it has the important distinction of being a no-SQL solution and stores data as tuples. This has many advantages and disadvantages over a SQL-based solution but in most cases MySQL will remain an easier and more popular option.
It is extremely well-suited for use cases across a broad range of applications such as e-commerce and business applications, and most small to larger organizations will find it well-suited for their data storage needs for a particular application. However, it is not designed for data warehousing and would not do well for analytics data for which a No-SQL option would serve better, and it is not ideal for geographical data management.