simpledb

How should I handle eventual consistency in SimpleDB, particularly in relation to unit testing?

We're building a web app on top of the Amazon Web Services stack, and I'm loving it so far. We're also making full use of test driven development and that is also proving to be fantastic. I'm just hoping someone can help me out with an issue I've come across which relates to Amazon SimpleDB's "eventual consistency". The best example o...

SimpleDB as Denormalized DB

In an environment where you have a relational database which handles all business transactions is it a good idea to utilise SimpleDB for all data queries to have faster and more lightweight search? So the master data storage would be a relational DB which is "replicated"/"transformed" into SimpleDB to provide very fast read only queries...

Best database for high write (10000+ inserts/hour), low read (10 reads/second)?

I'm developing a web app and currently using sql server 2008 for it. But, I am considering moving to another database (simpledb) for improved performance. I have a background process that inserts up to 10000 rows every hour into one specific table. That table is also read from to display data in the web application. When the background...

simpledb, sql azure, mysql + memcached

For a new scalable high traffic global ecommerce website (asp.net) project which technology fits best (max. scalability & performance, min. price & maintenance)? amazon simpledb, microsoft sql azure, mysql + memcached combo, or your solution... ...

PHP Implementation of an OAuth Store for Amazon SimpleDB

I am implementing OAuth for delegated access to our API for OnePage (http://myOnePage.com). We are using SimpleDB for our database. Does anyone know of a PHP OAuthStore implementation for SimpleDB? Or any other language for that matter, would be useful. If I don't find anything, I shall be coding it myself and will contribute it back t...

Can I delete by attribute in Amazon SimpleDB without specifying an ItemName?

Can I delete by attribute in SimpleDB without providing an ItemName parameter in the query string? The way I store my data is the item names are UUIDs, so I don't know the UUID of the data I want to delete. Is there a way to just specify an attribute and have it delete all items with that attribute? ...

Can I use associations when using Ruby on Rails w/Amazon SimpleDB?

For a new project my company is considering using Amazon SimpleDB to simplify data storage. The app is a simplistic web dashboard that will be created using Ruby on Rails. What I'm wondering, though, is if I can still use associations like has_many and belongs_to while using SimpleDB as the backend. For instance, the application has u...

Amazon SimpleDB Woes: Implementing counter attributes

Long story short, I'm rewriting a piece of a system and am looking for a way to store some hit counters in AWS SimpleDB. For those of you not familiar with SimpleDB, the (main) problem with storing counters is that the cloud propagation delay is often over a second. Our application currently gets ~1,500 hits per second. Not all those hi...

Enumerate keys in Amazon SimpleDB

I'm trying to enumerate keys in Amazon SimpleDB. In SQL, it would be something like: select unique itemName() from domain; I've searched around but didn't find any way to do this. Any help? ...

Is there a production grade SimpleDB .NET library?

Here you will find all the SimpleDB code samples on the AWS page. Here you will find a VB.NET SimpleDB library. Is there a production grade SimpleDB library, preferable built in C#. If not, May I use the VB.NET library on a C# project as a reference? ...

How far can one take SimpleDB, OpenID and the Cloud?

I have an ASP.NET MVC app (non-transactional, social) I am workong on. I started using the .NET authorisation provider which does the job, but with the Cloud's lining getting more shiny by the day I was wondering just how much I can push up. Ultimately I want to do away with my ISP-hosted SQL Server database and to progressively start u...

What tools do you use to administer analyze and otherwise manage your AWS SimpleDB(s)?

I'm working on OS X, so it has to at least work there, but I generally prefer tools that support multiple platforms. It's possible that I'm being too picky, but the JavaScript demo that Amazon provides doesn't quite seem like enough... ...

How to do paging with simpledb?

I know how to page forward with SimpleDB data by using NextToken. However, how exactly does one handle previous pages? I'm on .NET, but I don't think that matters. I'm more interested in the general strategy. Mike Culver's An Introduction to Amazon SimpleDB webinar mentions that breadcrumbs are used, but he doesn't implement them in ...

SimpleDB vs Tokyo Cabinet

Has anybody compared SimpleDB and Tokyo Cabinet for performance and scalability? I'm coding my project against SimpleDB at the moment and considering benchmarking TC, be nice if somebody had already done it and could tell me whether it's worth testing my specific storage and searching operations. If not I'll run some direct comparisons a...

db design with simpledb, examples?

Are there any examples of a before/after of what a database looks like when going from a traditional db to simpledb? ...

Any Blogging software using Amazon SimpleDB?

Is there any Blogging software (preferably .Net based) that uses Amazon SimpleDB for persistence? ...

is simpledb very much like mongodb? key/value type db?

is simpledb very much like mongodb? ...

Can I create domain schema only (without any data) in Amazon SimpleDB?

Hello. I am evaluating Amazon SimpleDB at this time. SimpleDB is very flexible in the sense that it does not have to have table (or domain) schemas. The schema evolves as the create / update commands flow in. All this is good but while I am using a modeling tool (evaluating MindScape LightSpeed) I require the schema upfront, in order for...

SimpleDB direct client access

One of the useful things about S3 for content storage is that a client can directly make a direct HTTP request to download the object. For instance, this is how Twitter serve up avatar images. SimpleDB provides an HTTP interface to data. Rather than having to write a proxy that sits inbetween SimpleDB and the client, is it possible for ...

How does Amazon.com function with a key-value datastore?

I have heard that Amazon uses a key-value data store - that it does not use a traditional relational normalized db. Speaking as someone who only has used the traditional approach, how does this work? Don't you need to do the following? select * from book where book_id = n Or a: select * from book where author_id = y How can you b...