Has anyone considered using something along the lines of the Amazon SimpleDB data store as their backend database? SQL Server hosting (at least in the UK) is expensive so could something like this along with cloud file storage (S3) be used for building apps that could grow with your application. Great in theory but would anyone conside...
When would you use a bigtabe/simpledb database vs a Relational database? ...
I am just beginning to do research into the feasibility of using Amazon's SimpleDB service as the datastore for RoR application I am planning to build. We will be using EC2 for the web server, and had planned to also use EC2 for the MySQL servers. But now the question is, why not use SimpleDB? The application will (if successful) need t...
New school datastore paradigms like Google BigTable and Amazon SimpleDB are specifically designed for scalability, among other things. Basically, disallowing joins and denormalization are the ways this is being accomplished. In this topic, however, the consensus seems to be that joins on large tables don't necessarilly have to be too ex...
I really want to use SimpleDB, but I worry that without real locking and transactions the entire system is fatally flawed. I understand that for high-read/low-write apps it makes sense, since eventually the system becomes consistent, but what about that time in between? Seems like the right query in an inconsistent db would perpetuate ha...
I am in the early stages of design of an application that has to be highly available and scalable. I want to use an eventual consistency data model for this for a number of reasons. I know and understand why this is an unpopular architectural choice for many solutions, but it's important in my case. I am looking for real-world advice, b...
If not, are there any fundamental limitations of the service that prevent one from being built? ...
After a down vote, I humbly realized that my post was an enormous rant. So I've edited it and summed this down to just the question I'd really like to know. I apologize for my brash comments prior to this edit ;) It seems that the only tutorials out there talking about using Amazon's SimpleDB in a rails site are using AWSDBProxy... Per...
Do you know if there is a way of using Amazon SimpleDB with NHibernate? LightSpeed seems to be compatible. ...
I thought that I could use SimpleDB to take care of the most challenging area of my application (as far as scaling goes) - twitter-like comments, but with location on top - till the point when I sat down to actually start implementing it with SDB. First thing, SDB has a 1000 bytes limitation per attribute value, which is not enough even...
Amazon's SimpleDB stores values as strings, and I need to store numeric values so that they still compare correctly, for example: "0001" < "0002" I think bytes, integers and decimals will be fairly straightforward, but I'm a little unsure on the best way to handle singles and doubles, since they can be very small or large and would app...
I am wondering if anyone has any thoughts on the best way to perform keyword searches on Amazon SimpleDB from an EC2 Asp.Net application. A couple options I am considering are: 1) Add keywords to a multi-value attribute and search with a query like: select id from keywordTable where keyword ='firstword' intersection keyword='secondwo...
I'm creating an application that will be hosted on amazon EC2 and a lot of the data that'll be saved is more document oriented (as well as saving tweets and such related to those documents). Right now I'm at a crossroads... should I use simpleDB or couchDB? Whats the pros/cons of using either? Should I just try both for a month and dec...
The SimpleDB documentation includes this example request for a ListDomains method. Note that there are Signature, Timestamp, AWSAccessKeyId and Version subelements: <SOAP-ENV:Body> <ListDomainsRequest xmlns=" http://sdb.amazonaws.com/doc/2007-11-07"> <Signature>SZf1CHmQnrZbsrC13hCZS061ywsEXAMPLE<</Signature> <Tim...
Is there a Ruby library for Amazon's SimpleDB that can generate joins from Ruby classes? For example, if you define Ruby classes for Game and Ball, and each Game has one Ball, code should be generated that queries for the appropriate Ball given an instance of Game, much in the way ActiveRecord works. RightAWS is the most popular Ruby A...
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 Amazon SimpleDB service, and I can get it back. I just don't know how to handle the SimpleXML object th...
I'm interested in getting my head around AWS (amazon web services) and its viability as a back end for Siverlight applications. Initially I'm interested in using S3 and SimpleDB to store and manage a media library. Before I start I'm trying to identify the spikes in difficulty. Is it authentication, rest vs soap, cross domain policy, or...
I have seen PHP libraries for SimpleDB but nothing too interesting... are there any best practices or frameworks for this or should I just go at it? Thanks! ...
I am in the process of building an mobile application (iPhone/Android) and want to store the application data onto Amazon's SimpleDB, because we do not want to host our own server to provide these services. I've been going through all of the documentation and the maximum storage size of element values is 1024 bytes. In my case we need...
I'm interested in hearing about design strategies you have used with non-relational "nosql" databases - that is, the (mostly new) class of data stores that don't use traditional relational design or SQL (such as Hypertable, CouchDB, SimpleDB, Google App Engine datastore, Voldemort, Cassandra, SQL Data Services, etc.). They're also often ...