Amazon SimpleDB vs Amazon RDS

amazon-simpledb amazon-rds
Webnet picture Webnet · Nov 30, 2010 · Viewed 7.4k times · Source

I work at a small ecommerce site and we're looking to move to all Amazon hosted services and I'm unsure the exact difference in RDS and SimpleDB. RDS can use MySQL, can SimpleDB not?

Answer

Lynn Langit picture Lynn Langit · May 16, 2012

Simply put, I would assume that because your business model is e-commerce that you need transactional consistency in your data solution. Because of this, you should choose one of the RDS options (these are MySQL, Oracle or SQL Server).

AWS SimpleDB is a non-relational data store (or NoSQL), so what you get is flexibility (i.e. schema-less or schema-light) and scalability, but what you don't get is immediate (transactional) consistency and also the query pattern will not use joins.

Related questions

Amazon SimpleDB vs Amazon DynamoDB

I have some basic understanding what Amazon SimpleDB is, but according to the Amazon DynamoDB description it seems to be almost the same: a NoSQL Key-value store service. Can someone simply explain the main differences between them and tell in …

Read More
Looping through a SimpleXML object, or turning the whole thing into an array

I'm trying to work out how to iterate though a returned SimpleXML object. I'm using a toolkit called Tarzan AWS, which connects to Amazon Web Services (SimpleDB, S3, EC2, etc). I'm specifically using SimpleDB. I can put data into the …

Read More
bigtable vs cassandra vs simpledb vs dynamo vs couchdb vs hypertable vs riak vs hbase, what do they have in common?

Sorry if this question is somewhat subjective. I am new to 'could store', 'distributed store' or some concepts like this. I really wonder what do they have in common and want to get an overview on all of them. What …

Read More