simpledb

Amazon SimpleDB

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...

Choosing a database type

When would you use a bigtabe/simpledb database vs a Relational database? ...

What do you need to take into consideration when deciding between MySQL and Amazon's SimpleDB for a RoR app?

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...

Pro's of databases like BigTable, SimpleDB

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...

How far can you really go with "eventual" consistency and no transactions (aka SimpleDB)?

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...

Eventual Consistency

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...

Has anyone tried building an ASP.NET Session State Provider for Amazon SimpleDB?

If not, are there any fundamental limitations of the service that prevent one from being built? ...

Are you using AWSDBProxy? Is there a performance hit when scaling out?

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...

SimpleDB dialect for NHibernate

Do you know if there is a way of using Amazon SimpleDB with NHibernate? LightSpeed seems to be compatible. ...

What's the point of using Amazon SimpleDB?

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...

Best way to format single & double values as strings for SimpleDB?

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...

Best way to keyword search Amazon SimpleDB using EC2 and Asp.Net?

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...

Should I use CouchDB or SimpleDB?

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...

Is the Amazon SimpleDB WSDL for SOAP without WS-Security correct?

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"&gt; <Signature>SZf1CHmQnrZbsrC13hCZS061ywsEXAMPLE&lt;</Signature> <Tim...

SimpleDB library with joins in Ruby

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...

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 Amazon SimpleDB service, and I can get it back. I just don't know how to handle the SimpleXML object th...

AWS & Silverlight do you have any notes from the field

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...

Best options for building a web app with SimpleDB as a data source?

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! ...

AWS SimpleDB

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...

Non-Relational Database Design

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 ...