amazon-simpledb

How different is Amazon Simple DB from Apache CouchDB?

Other than the monetary aspects, how different is Amazon's SimpleDB from Apache's CouchDB in the following terms Interfacing with programming languages like Java, C++ etc Performance and Scalability Installation and maintenance ...

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

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

Cassandra Vs Amazon SimpleDB

I'm working on an application where data size and SQL queries are going to be heavy. I am thinking between Cassandra or Amazon SimpleDB. Can you please suggest which is more suitable in this kind of scenario? Cassandra data indexing seems better than Amazon simpleDB, but the queries have fewer options compared to Amazon SimpleDB. Seems ...

Handling variety of content types in the persistence layer.

Hello. In my site, I'll be inviting people to contribute variety of content, like pictures, video, and things alike. Besides the core content, I'll be capturing meta data. Some meta data will be common across content types and some will be specific. I am planning to have 1 table that accommodates universe of meta data with that many c...

Best 'logging' option on Amazon Cloud. RDS or SimpleDB?

Hello. My site's architecture includes ASP.Net & MySQL. I am planning to deploy it on Amazon Cloud. This would mean EC2 instance(s) and RDS. My query is regarding logging. I'm ensuring that my application is stateless, so logging on application tier is ruled out. All state/persistence goes into RDS. When it comes to logging, I am not ...

AWS Simple DB Management Tool

I'm using Amazon SimpleDB for my web application. I'm looking for a tool like phpMyAdmin that will allow me to administer the database from one place (see all my Domains, view all records - run test queries etc) but all I can find is the free firefox plugin from Bizo http://dev.bizo.com/2008/12/open-source-simple-db-firefox-plugin.html...

Amazon SimpleDB for development environment / local installation.

Hello. Is there a way / tool to simulate Amazon's SimpleDB for the purpose of development? In my quest for above, I found this tool but this is for the Mac OS. Anything that can be installed on Win XP? Needless to say, all SimpleDB APIs need to be supported. Just in case it matters, mine is a .Net based web application. ...

Renaming and/or copying domains in Amazon SimpleDB

Hi all, My client decided to change the name of the project and requires that I change the domain names in our SimpleDB. I could not find any way, service, API call or tool to allow me to do that. I tried using the AWS tools for Eclipse as well as some other 3rd party tools. At most, they allow you to delete a domain or export its conten...

Uneven Results Doing A Sort / Orderby on Amazon SimpleDB

I've been getting really uneven results trying to request a numerically sorted list of records from Amazon SimpleDB. I am zero padding my numbers to get them selected lexigraphically, but still no luck. These two queries are giving the same result, for example: select * from cbcallers where calls_completed is not null order by calls_...

SimpleDB to ActiveResource. Rails

Im looking for a way to map an ActiveResource to SimpleDB I want to avoid plugins/gems as all I have used are outdated/buggy/not mantained It doesnt seem hard, I wonder if any of you have succesfully implemented a rails app with simpleDB as an Active Resource. How did you do it? Thanks. ...

SimpleDB as the main database, examples.

Please, can you give examples of real-life implementations using SimpleDB as the main persistent storage? ...

How can I script an alert for when my Amazon Web Service usage goes above a certain amount?

We're using S3, SimpleDB and SQS on quite a complicated project. I'd like to be able to automatically track their usage, to be sure we don't suddenly spend large amounts of money when we didn't intend to (perhaps because of a bug). Is there a way of reading the usage figures of all Amazon Web Services and/or the current real time dolla...

Any client libraries that implement MVCC over Amazon SimpleDB?

Now that Amazon's SimpleDB implements consistent reads and conditional update/delete it is possible to implement cross-domain transactions using MVCC. Are there any client libraries that provide it? ...

Iterating over all items in SimpleDB

Let's say I have a AWS SimpleDB domain with around 3 million items, each item has an attribute of "foo" with a value of some arbitrary integer (which is of course actually stored in SimpleDB as a string, but let's ignore the conversion to and from for now). I would like to increment the foo value for each item every 60 seconds, until it ...

Amazon SimpleDB Identity Seed equivalent

Is there an equivalent to an identity Seed in SimpleDB? If the answer is no, how do you handle creating something like a customer number or order number that will prevent the creation duplicate numbers? My experience is mainly from SQL Server in which I would either create a primary key with an identity seed or use transactions in a...

Question about Non-Relational Databases (NoSQL)

Although I've not yet used any of the new NoSQL databases I've tried to keep myself informed by reading Wikipedia articles, blogs and the peeking into some of the NoSQL DBs documentation. I've just (re)read the August 2009 edition of php|architect, specifically the article about the Non-Relation Databases and a few questions popped up i...

running "complex" queries with amazon SDB (simpledb) - aws-sdb + ActiveResource

I am considering the following a "complex" query, given the fact that simpledb is a really simple data storage: I am trying to query a aws-sdb domain with an OR query. using ruby, rails (2) and ActiveResource. I am using the code examples from http://developer.amazonwebservices.com/connect/entry.jspa?externalID=1242 (which don't show Or ...

How to extend an existing Ruby on Rails CMS to host multiple sites?

I am trying to build a CMS I can use to host multiple sites. I know I'm going to end up reinventing the wheel a million times with this project, so I'm thinking about extending an existing open source Ruby on Rails CMS to meet my needs. One of those needs is to be able to run multiple sites, while using only one code-base. That way, whe...