<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 8.8 out of 101
Based on 95 reviews and ratings
Likelihood to Recommend
For a general-purpose workload, RDS is a perfect fit and works really well and takes care of a lot of stuff for you (replication, security, monitoring, scaling, storage, publishing logs to CloudWatch). If you have a read-intensive load though, you should probably think of switching to a NoSQL database service like DocumentDB or DynamoDB.
- Super easy for quick development and investigation
- The interface of exporting tables to SQL can be made better, it's not easy to manually check
- Not suitable for designing your DB
- Connections over SSH to vagrant and Docker hosted DBs
- Auto suggestion can be better
- End-to-end management of your database -- including configuration, handling security, and maintenance.
- Offers compatibility with many (and the most popular) database technologies -- including but not limited to MySQL, Postgres, Microsoft SQL Server, Oracle DB.
- Makes backups and replications very easy, which is one of the toughest things to do effectively.
- Ability to quickly connect to a variety of databases.
- Ability to see the schema and data within the tables so you don't have to go looking for it.
- Theoretically, the ability to have multiple connections open in multiple tabs at the same time (see problems section for why I say "theoretically").
- Ability to write queries and have them execute locally.
- Quickly see relations between tables and rows in tables.
- My engineers would be able to speak more thoroughly to the cons. I have only benefited from the fruit of their labor. I can say that, from a Project Management standpoint (interfacing with RDS via a PostgreSQL client and my dashboards), it has only performed well so far.
- Improving the way we create new connections to remote databases
- I couldn't find any way to configure my local server (MySQL), so I need to make changes on server outside the application. I know that there are other tools that integrate it, so you don’t have to leave the workflow
- It could have a feature to integrate our databases or connections (favorites) with other devices, like using Google Drive or Dropbox. It would be really useful!
Amazon RDS 8.3
Based on 3 answers
I've been using AWS Relational Database Services in several projects in different environments and from the AWS products, maybe this one together to EC2 are my favourite. They deliver what they promise. Reliable, fast, easy and with a fair price (in comparison to commercial products which have obscure license agreements).
No answers yet
Amazon RDS 9.1
Based on 7 answers
Support for overall AWS services is a 10. We had one issue with creating a dev / stage / prod database within Aurora and a quick call with Amazon allowed us to figure out the issues we were having and it was determined it was how we were creating our initial setup of the databases
Sequel Pro 6.0
Based on 2 answers
The software has been crashing randomly since 2016, the dev branch has had the fix for a while now but for some reason it has not been merged to stable branch.
Our other application components are all hosted within Amazon's systems already, and the tight coupling of RDS with the security groups and virtual private cloud offerings made locking down privacy and security much easier than integrating with an outside provider. The deeper support for Postgres also made it easier to make the decision for Amazon as that database was higher on our wish list.
Sequel Pro's major competitor is Oracle's MySQL Workbench, a multi-platform MySQL server management software. While MySQL Workbench is more robust and feature complete, it doesn't beat Sequel Pro in terms of simplicity while providing all the power a pro would need.
Return on Investment
- RDS makes projects much easier. Set up time is decreased, and it is very easy to create and destroy databases as needed for testing.
- The ability to call AWS tech support for database-level issues and advice is a money saver if you don't have a high-end DBA on your team or need someone else to set things up with a little assistance.
- It is cheap and easy to grant secure access to your RDS instances to other companies or divisions of your company that use AWS.
Manager in Information TechnologyE-Learning Company, 51-200 employees
- Saves time in connecting to server-side MySQL databases because it remembers key info needed to set up the SSH tunnels.
- Makes it easy to do backup and restore of MySQL databases with minimum downtime.
- Provides a quick and easy way to access, review and edit the underlying data in any MySQL database or table using behind any of our company's web applications.
Premium Consulting/Integration Services—
Entry-level set up fee?