Amazon Athena vs Amazon RDS for Aurora: What are the differences?
Developers describe Amazon Athena as "Query S3 Using SQL". Amazon Athena is an interactive query service that makes it easy to analyze data in Amazon S3 using standard SQL. Athena is serverless, so there is no infrastructure to manage, and you pay only for the queries that you run. On the other hand, Amazon RDS for Aurora is detailed as "MySQL and PostgreSQL compatible relational database with several times better performance". Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. Amazon Aurora provides up to five times better performance than MySQL at a price point one tenth that of a commercial database while delivering similar performance and availability.
Amazon Athena can be classified as a tool in the "Big Data Tools" category, while Amazon RDS for Aurora is grouped under "SQL Database as a Service".
"Use SQL to analyze CSV files" is the primary reason why developers consider Amazon Athena over the competitors, whereas "MySQL compatibility " was stated as the key factor in picking Amazon RDS for Aurora.
Medium, StackShare, and Zumba are some of the popular companies that use Amazon RDS for Aurora, whereas Amazon Athena is used by Auto Trader, Zola, and Twilio SendGrid. Amazon RDS for Aurora has a broader approval, being mentioned in 121 company stacks & 31 developers stacks; compared to Amazon Athena, which is listed in 50 company stacks and 18 developer stacks.
Sign up to add or upvote prosMake informed product decisions
Sign up to add or upvote consMake informed product decisions
What is Amazon Athena?
What is Amazon Aurora?
Need advice about which tool to choose?Ask the StackShare community!
Sign up to get full access to all the companiesMake informed product decisions
Sign up to get full access to all the tool integrationsMake informed product decisions