A scalable and effecient database tool
December 19, 2018
A scalable and effecient database tool
Score 8 out of 10
Vetted Review
Verified User
Overall Satisfaction with MySQL
MySQL is currently being used to compile and back up data being generated by our OCR software. It is specifically used within our team for this purpose and means we have a stable, scalable and structured environment for the data.
- A strong and scalable environment. This is key for our use case as each application requires it's own database and a set of tables that are unique to the application. As we have 5 applications in 7 months, we need to easily scale up the project which MySQL is great for.
- A good community of users readily available online. We are able to look up any issues we may have quite quickly.
- It employs a simple coding language that is almost conversational in some instances and this allows for any new developer to pick up the tool with ease. Whilst it's simple, the language allows you to do in depth queries with ease.
- Easier walkthroughs for the reporting tools. We've had some difficulty building up reports from the databases, in order to regularly feedback to the business and there has been little assistance available.
- Setting up a new database can be cumbersome at times, particularly when we want very similar standard tables in each instance, and creating these from scratch has slowed down work a little.
- The ability to save a project in its entirety. We run individual queries across a range of different databases and we have had difficulty grouping these together as a single reusable project in order for us to implement in each new application.
- Allowed us to store data from letters accurately
- Allowed us to make better business decisions based on data
- Allowed us to work quicker and more effecient with a good tool
MySQL is much better. It is much more scalable.
Using MySQL
| Pros | Cons |
|---|---|
Like to use Easy to use Technical support not required Well integrated Consistent Quick to learn Convenient Feel confident using Familiar | None |
- Database queries
- Data management
- Spinning up new DBs
Yes, but I don't use it