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

MySQL

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
800 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>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 noreferrer'>Customer Verified: Read more.</a>
Top Rated
440 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.1 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 extremely well-suited for use cases across a broad range of applications such as e-commerce and business applications, and most small to larger organizations will find it well-suited for their data storage needs for a particular application. However, it is not designed for data warehousing and would not do well for analytics data for which a No-SQL option would serve better, and it is not ideal for geographical data management.
Joel Tanzi | TrustRadius Reviewer

SQL Developer

Oracle SQL Developer is well-suited for all companies that are using Oracle SQL Databases. First and foremost, it is absolutely free, and there are many free in-depth tutorials and documentation online to answer all of your questions. No matter the amount of experience, I am sure all database administrators will be able to work much more productively with their organization's databases through this IDE.
Anonymous | TrustRadius Reviewer

Pros

MySQL

  • MySQL is first off free to use, so that makes it a win right there.
  • MySQL is constantly updated and security holes are patched quickly and often.
  • MySQL is highly customizable and allows you access to all areas of the database to use it the way you want, plus there is lots of documentation online and other users sharing their customization experiences to help you along the way.
Andrew Shannon | TrustRadius Reviewer

SQL Developer

  • Export SQL results to a spreadsheet. After a query is run, you are able to export the results to a spreadsheet
  • Easily preview data columns on an Oracle table or view and the metadata on those columns.
  • SQL Editor is color-coded so that you can tell easily what are keywords.
  • You can set up SQL code templates to be able to use shortcut keys to format your SQL query easily in a readable format that you prefer.
Anonymous | TrustRadius Reviewer

Cons

MySQL

  • Complex queries usually require many resources to obtain results. Other software does not present this situation.
  • MySQL has stopped its evolutionary process since its change of ownership, so the changes it presents have become irrelevant to the operation of the service.
  • Oracle has avoided releasing the code for the detection and correction of errors so the essence of open source has been disappearing
Carlos Alberto Pedron Espinett | TrustRadius Reviewer

SQL Developer

  • Setup can be challenging if your schemas aren't well formed or managed. Also, the ability to model/develop extensions for an existing database solution will depend on how robust the DBA provisioned roles and designed the respective schemas.
  • Detailed analysis of models can be clunky for complex relational models.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

MySQL

MySQL 9.7
Based on 4 answers
It is best open source relational database.
Yinghua Hu | TrustRadius Reviewer

SQL Developer

SQL Developer 8.0
Based on 1 answer
No answer on this topic is available.

Usability

MySQL

MySQL 8.2
Based on 5 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

No score
No answers yet
No answers on this topic

Support Rating

MySQL

MySQL 8.6
Based on 2 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 8.0
Based on 1 answer
No answer on this topic is available.

Alternatives Considered

MySQL

We actually use Sisense alongside MySQL as they integrate very well with one another. One of MySQL's flaws is its slow speeds on larger datasets which is why we began using Sisense. This way, we can organize several feeds into one source without having to do repetitious work on different sources.
Joseph R. Sweeney | TrustRadius Reviewer

SQL Developer

Toad and SQL developer are often compared and we considered both at the beginning. Arguably, Toad outperforms SQL developer in terms of many functionalities. The biggest reason we encouraged our engineers to use SQL developer was cost. Although it is not enriched like Toad, it is still a very well functioning and supported product.
Anonymous | TrustRadius Reviewer

Return on Investment

MySQL

  • MySQL has been a vital cost reducing technology for smaller databases that do not require commercial support.
  • We have successfully sold the enterprise edition to customers who wanted to beef up the capabilities of MySQL compared to the community edition without rewriting an application to use a fully commercial database such as DB2, Oracle or SQL Server
  • MySQL has been extremely cost effective where we have deployed it. When compared to Oracle or MySQL, the savings has been substantial.
Christopher Weiss | TrustRadius Reviewer

SQL Developer

  • SQL Developer is a free tool that comes with the licenses of Oracle Database, so it's quite inappropriate to talk about ROI of this software itself.
  • SQL Developer is not a "you get what you pay for" product. Using it can cut out an entire line from your budget, so there is no comparison in that regard. We now only buy a few licenses for other similar tools and only when the user can prove SQL Developer doesn't meet the need.
  • In some cases, new programmers come in that are not familiar with SQL Developer. People tend to like what is familiar, so there is some initial time spent learning the tool. But that is balanced out because it really is pretty intuitive.
Krishan Mohil | TrustRadius Reviewer

Pricing Details

MySQL

General

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

SQL Developer

General

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

Add comparison