What users are saying about

1010data

5 Ratings

MySQL

569 Ratings

1010data

5 Ratings
Score 5.2 out of 101

MySQL

569 Ratings
Score 7.9 out of 101

Add comparison

Likelihood to Recommend

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.

MySQL

MySQL is great for research projects, startups, non profits etc... Basically MySQL is great for any one or any company that is budget minded. MySQL is also very good for products that are high read / low write scenarios especially when using the InnoDB engine.

Pros

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
  • MySQL is very easy to setup and use. You can create a new MySQL instance in a matter of minutes.
  • MySQL comes with a great set of tools out of the box that make database administration as easy as possible. Everything from creating or restoring backups to setting up remote server replication is doable with the built in tools.
  • MySQL is highly configurable and can be easily tuned to suit the individual needs of the user.

Cons

  • The ten.do interface could use more detailed documentation
  • Because MySQL is so highly configurable, there is a bit of a learning curve when getting started. Getting setup is easy but research into the different storage engines and tuning parameters is required to make MySQL really efficient for your business needs.
  • MySQL uses some non standard SQL syntax by default that can take some getting used to.
  • Some SQL standards are implemented in very non standard ways so that tasks are able to be accomplished but the statements created for the task don't translate well to other RDBMS.

Likelihood to Renew

No score
No answers yet
No answers on this topic
MySQL9.1
Based on 2 answers
For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.

Usability

1010data8.0
Based on 1 answer
That's votes by our team.
MySQL8.2
Based on 2 answers
You can use MySQL for TOAD or MySQL Workbench for a nice GUI experience.

Alternatives Considered

While we have used SQL, 1010data is really the only industry standard product available for our use.
Compared to Oracle MySQL is lacking some of the advanced features Oracle provides but through a detailed business and technical requirements capture process it became clear we would not need these very advanced features. Oracle is stronger on the backup and restore side of things and here I mean it does seem quicker using Oracle to import/export very large databases/indexes and partitions however we decide to live with the difference. All in all set up and ongoing costs was a significant factor in our decision to use MySQL.Our business doesn't have significant SQL Server expertise and with the costs and limited choice of OS involved of using SQLServer we eliminated it at a very early stage.

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
  • Project Setup Costs - As MySQL is under a GPL licence and for our project there we no licensing costs (you need to check you are covered for your project). This has a huge saving compared to using Oracle and other such heavy weights.
  • Development Cycle - We found that MySQL was well suited for using it within Lean/Agile software development environments. Changes can be made quickly without being over complicated to implement and most of the time by an application DBA or a middleware developer.
  • Cluster Design - To date we have had no DB outages (we are using a HA cluster design) and therefore lead to cash and end customers T2R processes have been 100% available.

Pricing Details

1010data

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

MySQL

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details