Likelihood to Recommend Amazon Relational Database Service is a perfect fit for everyone who is seeking for an high-performance cloud-based database service. No matter if Postgres, Oracle, or any other type of relational database. Amazon RDS is our first choice for any kind of database requirement in the cloud. Especially I like the scalability.
Read full review High-performance, high-concurrency transactions are well suited for ASE. ASE is lacking some features in my opinion such as history tables, however there are ways to implement them via workarounds or by using Replication Server. I do think the way the ASE parser and optimizer works are far superior to other products as it is a true cost-based optimizer and the order of the tables in the FROM clause does not really matter although a good SQL coder will place the tables in a meaningful order to make the SQL more readable. ASE is good for applications that require high availability and can be used for mission critical systems.
Gene Baker Vice President, Chief Architect, Development Manager and Software Engineer
Read full review Pros Automated Database Management: We use it for streamlining routine tasks like software patching and database backups. Scalability on Demand: we use it to handle traffic spikes, scaling both vertically and horizontally. Database Engine Compatibility: It works amazingly with multiple database engines used by different departments within our organization including MySQL, PostgreSQL, SQL Server, and Oracle. Monitoring: It covers our extensive monitoring and logging, and also has great compatibility with Amazon CloudWatch Read full review Easy to setup and maintain Reliable, rarely has major hiccups requiring reboots or crashes Very responsive with complicated queries spanning various tablespaces and hundreds of millions of rows Read full review Cons It is a little difficult to configure and connect to an RDS instance. The integration with ECS can be made more seamless. Exploring features within RDS is not very easy and intuitive. Either a human friendly documentation should be added or the User Interface be made intuitive so that people can explore and find features on their own. There should be tools to analyze cost and minimize it according to the usage. Read full review Full database encryption - need to utilize external keys vs internal - for better separation of duties. History Tables. Gene Baker Vice President, Chief Architect, Development Manager and Software Engineer
Read full review Likelihood to Renew We do renew our use of Amazon Relational Database Service. We don't have any problems faced with RDS in place. RDS has taken away lot of overhead of hosting database, managing the database and keeping a team just to manage database. Even the backup, security and recovery another overhead that has been taken away by RDS. So, we will keep on using RDS.
Read full review Our licenses are perpetual. It is the support that we will be renewing. We will renew because we continue to use and receive value from the product.
Gene Baker Vice President, Chief Architect, Development Manager and Software Engineer
Read full review Usability 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).
Read full review It does almost everything we need and for the things it doesn't do natively, we are still able to do using other features. For example, natively history tables weren't supported but we were able to create them using triggers.
Gene Baker Vice President, Chief Architect, Development Manager and Software Engineer
Read full review Support Rating I have only had good experiences in working with AWS support. I will admit that my experience comes from the benefit of having a premium tier of support but even working with free-tier accounts I have not had problems getting help with AWS products when needed. And most often, the docs do a pretty good job of explaining how to operate a service so a quick spin through the docs has been useful in solving problems.
Read full review Incredibly responsive, saving us countless hours in troubleshooting.
Read full review Online Training the online training & digital content available on the web from AWS was having sufficient information to deploy and run the service
Read full review Alternatives Considered In a few words, we are just to confortable working with oracle and sql server. Using RDS add another layer of distributed database in order to backup everything we have in case of a disaster and also complies with authorities locally and internacionally. All database we use, are local in custom servers that we maintain, but we agree to expand this.
Read full review Much less effort than Oracle. Much better customer support than Oracle. Roughly equivalent to SQL Server in performance and ease of use. Much better customer service than SQL Server. Different ballpark from IQ. Same customer service.
Read full review Return on Investment RDS is costly and thus small business should avoid it as it might not be worthful (in ROI perspective) Downtime is very low and there are automated backups thus we dont have to worry much about technical stuff and can focus more on marketing and sales Due to various automated features such as automated backup etc we dont need a huge technical team thus reducing the cost of maintaining a huge technical team , Read full review Negative - Costs a lot ... but so do they all. Positive - It does what we need it to do. Read full review ScreenShots