Best relational databasehttps://www.trustradius.com/open-source-databaseMySQLUnspecified8.57581012017-03-27T17:16:51.292Z
March 27, 2017
Best relational database
Score 10 out of 101
Overall Satisfaction with MySQL
We use MySQL for all our web applications in our company. We needed a relational database to store persistent user and business data. I have used PostgreSQL in the past and it's great too. Since PHP and MySQL are a more common stack, we have chosen MySQL over other databases. This is particularly useful if one chooses to migrate their infrastructure to a different vendor since a lot of them support MySQL out of the box. MySQL provides much-needed security, scalability and updates that are backed by Oracle.
- Large number of driver implementations for different languages. Programmer just needs to plug and play.
- Just like most of other relational databases, it is extremely advanced in terms of performance over complex queries.
- It's open source and is a cross platform application.
- It's relational.
- Inconvenient agile development and deploy because of very slow DDL for large tables.
- There is some uncertainty in licensing for Oracle's Community Edition. It's free but not free, more like freemium. Oracle needs to treat MySQL like the real open source product it was always intended to be.
- Query optimization can get a bit tricky if you are running a lot of complex queries, implying a bit of maintenance expenditure.
- MySQL has grown and has come a long way with its community and developers. Scaling was once an issue but now it's very much possible to scale as big as one wants.
- MySQL suits for applications of any size, especially data-driven applications.
- MySQL is known for web applications but it can be used for any kind of application.
- It is less appropriate if you don't have a need for a large database and complex tables and queries. In this case SQLite is a more suitable option.