Ok so I mis-stated something in a previous post on this topic. Earlier I mentioned that we had trouble with SimpleDB because during an insert/update operation it's default mode was to append.
For instance if you wanted to change the price of an item from $10.00 to $9.00 you would suddenly have a tuple (pair) in the price field containing both $10.00 and $9.00 which of course caused our software to freak out and begin vomiting profusely. That part was correct. What was incorrect was where I went on to say that there is no way to override this using the AWS Java API. Turns out this can in fact be changed by adding .withReplace(true) to the prepared statement. (I would love to know where this sort of stuff is documented Amazon). Thanks for bringing this to my attention, I'm going to go crawl back into my hole and fix a bunch of my code now :). /* PLUG: http://plug.org, #utah on irc.freenode.net Unsubscribe: http://plug.org/mailman/options/plug Don't fear the penguin. */
