Likelihood to Recommend
Amazon Relational Database Service is great when you need a Database solution that can work for you very fast. It is also a great solution when you need a system that can scale to handle very large amounts of data. You can get set up with a complex, large database eco-system in minutes/hours, and have the best security and backups scheduled. The alternative to doing this would typically be hiring one or more very experienced database professionals for not just the implementation, but also on staff to handle the periodic maintenance necessary.
When an existing MySQL table needs to be examined or edited, Sequel Pro excels. In the circumstance where a new table needs to be created, I believe phpMyAdmin might offer slightly better interface.
- Security... being in the AWS stack, you get all the "warm and fuzzies" that come with knowing your data is secure. And user management couldn't be easier.
- Flexibility... Aurora, PostreSQL, MySQL, Oracle, SQL Server--RDS can run any of them.
- Scalability... when all else fails, add more hardware! To a point... and there is a point (see: petabytes) at which you might consider bumping up to RedShift, but for the other 99.99%, RDS is the place to be.
- Editing existing data. Editing record contents is trivial in Sequel Pro, while not nearly as easy in MySQL Workbench or phpMyAdmin.
- Deleting data - even simpler than editing data.
- Inserting new data - using "Duplicate row" then making needed changes is very simple.
- 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!
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.
Return on Investment
Premium Consulting/Integration Services—
Entry-level set up fee?