Overall Satisfaction with MySQL
The choice to use MySQL was obvious because it was open source, easily accessible and free. I needed to deliver a web app that would target a small initial audience and scale to a wider audience in a short period of time. I could have chosen other offerings but I needed to deliver this app in a short delivery window. With the help of MySQL, I was able to meet that deadline and scale the app to thousands of users. While it was eventually replaced by another application, it always ran smoothly, and never went down. MySQL will always be my first database love.
- Quick deployment
- Ease of use
- Scalability
- Performance
- Full joins are not supported but you can emulate them
- No check constraints
- Negative impact of installing MySQL first and doing a rip-and-replace can prove costly. Depends on what you're building. This is where project scope is crucial.
- Positive impact of installing MySQL first is that the upfront licensing cost is nothing. You really have nothing to lose here.