simpledb

amazon simpledb with aws-sdb-proxy suitable for high traffic production app?

i am using amazon simpledb with the aws_sdb gem and aws-sdb proxy as outlined in a documentation from amazon with ruby on rails and a local aws proxy that runs on webrick (providing a bridge with ActiveResource). see http://developer.amazonwebservices.com/connect/entry.jspa?externalID=1242 i am wondering if the aws-sdb-proxy (webrick!)...

How do you calculate the storage size of a SimpleDB domain?

The official documentation states: Raw byte size (GB) of all item IDs + 45 bytes per item + Raw byte size (GB) of all attribute names + 45 bytes per attribute name + Raw byte size (GB) of all attribute-value pairs + 45 bytes per attribute-value pair What is the raw size of an attribute-value pair? Is it precisely the size...

Alternative databases to use when putting IIS Logs into a database using LogParser

We have run some scripts that use LogParser to dump our IIS logs into a SQL Server database. We can then query this to get simple stats on hits, usage etc. It's also good when linking it to error log databases and performance counter database to compare usage with errors, etc. Having implemented this for just one system and for the las...

SimpleDB query on attribute name

Hello, I don't know something like this is possible or not with simpledb. I am trying to use following type of simpledb data structure. Each item has multiple name/value pairs (name here is attribute-name) e.g. item1 serial_num -> value item2 serial_num -> value such number of items are there in a domain and there are mu...

SimpleDB query performance improvement using boto

Hello, I am trying to use the SimpleDB in following way. I want to keep 48 hrs worth data at anytime into simpledb and query it for different purposes. Each domain has 1 hr worth data, so at any time there are 48 domains present in the simpledb. As the new data is constantly uploaded, I delete the oldest domain and create a new domai...

Is there a database agnostic nosql framework for .NET?

I'm looking for a common data access framework that will provide portability across various nosql databases like SimpleDB, Azure Tables, Cassandra, CouchDB, MongoDb, etc. I'm building an app and would like my customers to be able to use which ever nosql store they want. In a more relational scenario, I'd use Linq over nHibernate or E...

Are any websites currently using the following non-relational databases as backend? 1.SimpleDB 2.CouchDB

I would also like to know if any sites have implemented any other non relational databases, and for what purpose.. ...

Grails and Amazon SimpleDB

How to setup Grails project to use Amazon SimpleDB? One possibility is to install gorm-jpa plugin and use SimpleJPA library, but I couldn't setup it correctly. Has someone experience with this combination? ...

Amazon SimpleDB Query to Find "Post By Friends"

I have been developing an iPhone app which queries a server that relays data I store in Amazon SimpleDB. I have a database table of "Submissions" by various users. I am interfacing with Facebook to retrieve Facebook Friends and wish to make a query to "Submissions" to find posts by friends - like: SELECT * FROM submissions WHERE userI...

Query for getting attributes value in simple db

hi, i am using simple db. in my simple db have "device.OS" attribute. i want that same attibute values for "device.OS". please help for this problem. NOte: i can try normal attribute value i can possible to get the value. but if "." is there in attribute name not possible to get the values. it shows "syntax error" Thanks, senthil ...

How can I export data from SimpleDB to Excel or TextPad?

Hi, I want to export data from SimpleDB to Excel or TextPad. How can I write a query for exporting data? Thanks, Senthil ...

Deleting ALL ItemsName() in a single Query in SimpleDB

HI, I want to delete all ItemNames in single query in simpledb. whether it's possible in simple db.If possible please give the query for deleting all items in simple DB Thanks senthil ...

Where can I find my SipmleDB domain sizes

The documentation says that simpledb domain size max is 10GB. However, I can't find anywhere that I can determine what my current domain sizes are. ...

How do I get the region endpoints from the Amazon SimpleDB API

So its easy to get the Amazon EC2 region endpoints simply via an API call (DescribeRegions) But how do I do this with the SimpleDB API, there is no obvious (to me) call. (and the endpoints are different, so I can't just use the EC2 one's) Edit: Oh, I'm using the .NET API ...

Commit protocol

Hi, I'm building a REST web service that receives a request and must return "Ok" if the operation was done correctly. How could I deal with the possibility of the loose of the connection while returning this "Ok" message? For example, a system like Amazon SimpleDB. 1) It receives a request. 2) Process the request (store and replicates...