What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
885 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
477 Ratings

MySQL

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
885 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100

SQL Developer

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
477 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100

Highlights

MySQL is an open source database software designed to allow for the storage and querying of structured data. Oracle SQL Developer is an integrated development environment (IDE) built to be used with Oracle database. Users of Oracle database software will prefer Oracle SQL Developer while MySQL users will need to use a different IDE such as Datagrip. With this in mind, this comparison will focus on the differences between MySQL and Oracle Database. Oracle Database and Oracle SQL developers are popular with mid-sized businesses and larger enterprises while MySQL is popular with businesses of all sizes.

Features

MySQL and Oracle Database both have essential database features including structured data storage and query-based data retrieval. Each database software also has a few standout features that set them apart from one another.

MySQL is an open source database software, meaning its source code is available online for free. Since MySQL is an open source software, it can be set up very affordably for businesses with technical staff. MySQL also offers high-performance querying, and fast read/write times. Additionally, MySQL supports a variety of programming languages including Java. Lastly, MySQL is a very scalable database software, which can make it an ideal choice for organizations expecting rapid growth.

Oracle Database is a proprietary database software, meaning users can benefit from the vast support resources available from Oracle as well as IDEs like Oracle SQL Developer. Additionally, Oracle Database includes robust SQL commands that allow for more complex reporting than other database software options. Oracle Database also provides support for the Ruby programming language and the Ruby on Rails Framework.

Limitations

MySQL and Oracle Database both include robust database features, but they also have a few limitations that are important to consider.

MySQL support and apps don’t have the same technical resources available as the team behind Oracle Database. This can be a problem for businesses with self-hosted instances of MySQL that lack the technical staff and need to lean on support teams. Additionally, MySQL doesn’t support many of the SQL commands included in Oracle Database. Organizations looking for the biggest feature set may be better served by Oracle Database’s wider set of features.

Oracle Database will be a pricier option for most organizations due to its proprietary nature. Its higher price may make Oracle Database a poor choice for organizations looking for an affordable database software option. Additionally, Oracle Database doesn’t scale as easily as MySQL, so businesses looking to grow quickly may want to consider other options.

Pricing

MySQL is an open source database software, so businesses are able to set up an instance of it at no charge. Many services offer hosting services and support for MySQL, where pricing is dependent on the host, as well as what features are included. Most MySQL hosting options also include free versions for small projects.

Oracle Database has to be purchased from Oracle, but pricing is similarly dependent on data needs as well as features. Oracle Database also includes a free version for businesses with minimal storage needs.

Likelihood to Recommend

MySQL

  • It is a suitable database for web applications where we have a large size of users. It is also easily scalable and provides good user management and access controls at the security level.
  • MySQL is a very fast database to read when using the non-transactional MyISAM engine, but it can cause integrity problems in high-concurrency environments when modifying. Thus, for applications with many parallel transactions and modifications, MySQL is probably not the best solution
Jose Manuel Ortega | TrustRadius Reviewer

SQL Developer

Almost all development activities (the tool is called "SQL Developer", not "DBA Toolset") can be done easily and quick with [Oracle] SQL Developer. From data model creation (tables, views) to development (creation of procedures, functions, packages) and then testing (SQL Developer includes an easy to use debugger), all tasks can be performed in a single tool.
It may not be as complete as other solutions for DBA tasks like instance monitoring, but it is usually OK for development and testing environments if you want to do some basic troubleshooting.
Lisandro Fernigrini | TrustRadius Reviewer

Pros

MySQL

  • 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.
Joel Tanzi | TrustRadius Reviewer

SQL Developer

  • Object Browser in SQL Developer allows you to explore the contents of your database using the connection tree.
  • The SQL Worksheet is an editor that allows for execution of SQL statements, scripts, and PL/SQL anonymous blocks. SELECT statements can be executed to return results in a spreadsheet-like 'grid' or can be executed as a script such to emulate SQL*Plus behavior and output
  • DBA Console allows users with administrative privileges to access DBA features such as database init file configuration, RMAN backup, storage, etc.
Joe He | TrustRadius Reviewer

Cons

MySQL

  • MySQL doesn't provide good data wrangling functionalities, such as parsing JSON or XML. We had to transform them outside MySQL on the web application server side using JSP.
  • As we move forward to adopt more genomics information, MySQL may lack of dealing with "big data" functionalities.
  • It is a freely available S/W and easy to manage budget, but there are possibilities to spend cost for additional technical support.
Anonymous | TrustRadius Reviewer

SQL Developer

  • Inability to run multiple queries on the same database. You can only run one query on a given database.
  • Analytical models created from complex tables isn't accurate, and needs work.
  • Inability to view multiple tables of a database side-by-side. When trying to find correlations between tables, it would help to be able to see them at once on the same page.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

MySQL

MySQL 9.9
Based on 4 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.
Anonymous | TrustRadius Reviewer

SQL Developer

SQL Developer 8.5
Based on 3 answers
It allows most users to perform daily activities in a simple way, with no cost since the tool is free.
Lisandro Fernigrini | TrustRadius Reviewer

Usability

MySQL

MySQL 10.0
Based on 6 answers
I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
Kenneth Hess | TrustRadius Reviewer

SQL Developer

SQL Developer 8.0
Based on 2 answers
It has lot of features that are required in SQL editor. It does the job well and is reliable. It is user friendly, integrates with different databases, and can be used for advanced database management activities.
Anonymous | TrustRadius Reviewer

Support Rating

MySQL

MySQL 8.6
Based on 4 answers
The support staff is friendly, knowledgeable, and efficient. I only had to get part way through my explanations before they had a solution. They will walk you through a fix or actually connect in and fix the problem for you--or would if you can allow it. I've done it both ways with them. They are always forthcoming with 'how to do this if it happens again' information. I love working with MySQL support.
Kenneth Hess | TrustRadius Reviewer

SQL Developer

SQL Developer 7.1
Based on 3 answers
Oracle support is good. In general a get good and quick answers to my questions.
Anonymous | TrustRadius Reviewer

Implementation Rating

MySQL

MySQL 8.0
Based on 2 answers
1. Estimate your data size.2. Test, test, and test.
Anonymous | TrustRadius Reviewer

SQL Developer

SQL Developer 9.0
Based on 2 answers
Just download and uncompress!
Lisandro Fernigrini | TrustRadius Reviewer

Alternatives Considered

MySQL

After Oracle bought MySQL, I have pivoted some projects to use MariaDB instead, which is a fork of MySQL and maintained by the community and original developers of MySQL. This is free under the GNU GPL, and is not impacted by decisions Oracle makes for MySQL. RDS has the ability to run managed MySQL instances which make it even easier to setup and configure a database. RDS also has support for MariaDB.InfluxDB is a great Time Series DB Platform which was designed to collect measurements with timestamps, and works more efficiently than MySQL for this type of data. I would recommend InfluxDB for anyone who is on the fence about implementing a collection agent and having the stats go into MySQL or another Database system
Anonymous | TrustRadius Reviewer

SQL Developer

I have started to use Toad for Oracle recently because it is easier to sort and filter results, due to their memory sort feature that puts the results from your query in memory so that you don't have to rerun your query. I have used SQL Developer to easily update records in tables that I need to fix. I haven't found an easy way to do this in Toad other than writing SQL insert statements.
Anonymous | TrustRadius Reviewer

Return on Investment

MySQL

  • Since MySQL is a free database package, if you have someone on staff that understands databases and how to use them, the ROI is very high when using MySQL.
  • If you need to hire a MySQL developer to implement and manage your database then it can be quite costly to manage and that will negatively impact your ROI when using this product.
  • Since there are some very expensive alternatives in the SQL database space, if you compare the overall costs of using MySQL to those other products, I think you will find your ROI is always better when using MySQL
Andrew Shannon | TrustRadius Reviewer

SQL Developer

  • It gives 100% return on investment as it is free of cost.
  • No need to have multiple tools for each database
  • Considering the employee training, so one can save money on training, as it is not very hard to use so still savings.
Binoy Shah | TrustRadius Reviewer

Pricing Details

MySQL

General

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

Starting Price

SQL Developer

General

Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No

Starting Price

Add comparison