3 ms·
There is a reason cloud services do not support full SQL - relational storage doesn't scale.
by ntoshev 18y ago
There is a reason cloud services do not support full SQL - relational storage doesn't scale.
- chime 18y agoI know that. But I find that a lot of my projects end up with 5-10GB database tables that I would rather not host myself. SimpleDB could fill my need quite well if I didn't have to rewrite all my apps to work with SimpleDB and instead could just change my SQL statements to work with Amazon. Think of it like a simplistic MySQL server that never goes down or has no scaling problems. The way SimpleDB is now is good but requires significant rewrites to existing applications that use any SQL backend.
- ntoshev 18y agoThen you should probably install MySQL on an EC2 instance with EBS attached. You need some rewriting even when you port to another relational db vendor. Amazon is definitely not headed towards administration-free experience, it aims for flexibility instead.