What users are saying about
50 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
Top Rated
381 Ratings
50 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.8 out of 101

SQL Developer

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

Likelihood to Recommend

Amazon Aurora

When already using a relational database, either MySQL or PostgreSQL, the change to Amazon Aurora should be very straightforward. The main benefits you get are cost efficiency and ease with regards to the storage, as it scales with you, and managing clusters including failovers are made very straightforward for you.If you are looking for a database which can scale up and down quickly with demand, Aurora may not be the best fit. However, there is now an Amazon Aurora Serverless service which attempts to address this requirement. I do not have any experience with it, so cannot comment further - but it is possible it will fit your use-case.
Andrew Raines profile photo

SQL Developer

It is fairly simple to use for new users or beginners in their SQL knowledge. It is easy to install and use to connect quickly to an Oracle Database. Great options for formatting your SQL code. I appreciate the reserved words being in a different color. It is hard to dig into your data with sorts and filters easily without having to rerun the SQL query. Sometimes this is painful when you have a long running query that you want to sort or filter and it then reruns the long-running query to make that happen
No photo available

Pros

Amazon Aurora

  • The MySQL compatibility meant we didn't have to change anything in our system which used to run on a MySQL database. It was a very simple configuration change to point at the new instance once set up
  • Much better performance than our previous MySQL database (hosted on AWS RDS) for lower costs due to the way storage is managed
  • Storage management is much more simple as it grows and shrinks with you without having to allocate and deallocate storage to the database
Andrew Raines profile photo

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.
No photo available

Cons

Amazon Aurora

  • I'd like to see Amazon Aurora get ahead of the curve on MySQL and introduce their own improvements to MySQL to make it a superior database so that I don't need to use SQL Server or Oracle to get performance improvements. For example, improve performance of views.
  • Amazon Aurora needs to improve the ability to restore backups as needed. Currently, the user can only restore an entire instance to a new or existing RDBMS instance. If you need to retrieve data from a single table, this can be tedious after waiting hours for an entire restore to complete. Instead, allow the user to select a database to restore. Better yet, allow the user to restore a database backup to ANOTHER database - which would allow you to restore a database on the same instance.
  • Again beat MySQL to the punch and introduce REAL server to server communication since they have disabled the "Federated Engine" which was the only way previously to do this. I'd like to be able to setup MySQL instances to talk to other MySQL instances.
No photo available

SQL Developer

  • Its connectivity to other databases and use of specific functions from it. Example: DB2.
  • Running many SQLs in parallel from a number of open SQL sheets. TOAD has this feature, very useful to toggle between different tabs.
Krishan Mohil profile photo

Alternatives Considered

Amazon Aurora

Aurora MySQL 5.6 lacks many of the features of PostgreSQL, and even more recent versions of MySQL or MariaDB. You may be able to tolerate these deficiencies; simple OLTP use-cases will be served adequately. Like RDS and DynamoDB, Aurora is managed and integrates well with other AWS products. Amazon Aurora Serverless can be much less expensive than RDS, however.
No photo available

SQL Developer

Now days it seems like most tools in these categories have all of the same features. They typically have niches where they are better at one thing than another tool in that category. SQL Developer's niche is obviously connecting to Oracle databases. That plus the fact that it is free makes it a no-brainer choice, especially if you work for a non-profit.
Dorrie Keyes profile photo

Return on Investment

Amazon Aurora

  • Aurora Serverless has allowed us to inexpensively implement best-practices for our microservices architecture.
  • Aurora is mostly managed; our engineers can focus on features instead of database administration.
  • Aurora is capable of high throughput. Speed is not our first priority, but we still benefit from it.
No photo available

SQL Developer

  • It minimizes time, which translates into cost savings.
  • Helps generate reports for end users more quickly and with less errors.
  • One tool can do what might otherwise require multiple tools.
No photo available

Pricing Details

Amazon Aurora

General

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

SQL Developer

General

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

Add comparison