Questions tagged [amazon-simpledb]

Highly available schema-less attribute database that is part of the Amazon Web Services offering. Enables storage and retrieval of named items consisting of one or more key/value string pairs organized into domains. Item retrieval is done either by item name gets or through a sql-like language. Pay for what you use model with no minimum fees or startup costs.

Amazon SimpleDB is a highly available schema-less attribute database that is part of the Amazon Web Services offering. Enables storage and retrieval of named items consisting of one or more key/value string pairs organized into domains. Item retrieval is done either by item name gets or through a sql-like language. Pay for what you use model with no minimum fees or startup costs.

References

390 questions
4
votes
3 answers

anonymous read with amazon simpledb

I would like to query simpledb directly from the client using javascript. My application is read-heavy and I rather not route the request through my application server. Is it possible to perform a select request without authentication? I could set…
Jack000
  • 157
  • 1
  • 10
4
votes
2 answers

Insert item only if it doesn't already exist

I'd like to add a new item to an Amazon SimpleDB domain only if there isn't already another item with the same item name. I know how to do it for an attribute. But I want the item name to be checked to make sure it's unique, and it won't overwrite…
Nick
  • 2,576
  • 1
  • 23
  • 44
4
votes
4 answers

Database design for high sample rate data, graphing at multiple zoom levels

I've got multiple sensors feeding data to my web app. Each channel is 5 samples per second and the data gets uploaded bundled together in 1 minute json messages (containing 300 samples). The data will be graphed using flot at multiple zoom levels…
Tim
  • 7,746
  • 3
  • 49
  • 83
4
votes
1 answer

Cost effectiveness of Amazon SimpleDB/RDS?

I'm looking at both of these services because I don't want to bother to maintain backups of my databases. My question is: how cost effective are these services? Specifically, how are they billed? I see that they're billed by hour, but what does this…
Alexander
  • 41
  • 1
  • 4
4
votes
2 answers

Amazon SDB - PUTS per second limit explained?

I believe the max PUT requests to Amazon's Simple DB is 300? What happens when I throw 500 or 1,000 requests to it? Is it queued on the Amazon side, do I get 504's or should I build my own queuing server on EC2?
4
votes
2 answers

How to escape Python boto's SelectExpression for Amazon SimpleDB

Currently my code is client = boto3.client('sdb') query = 'SELECT * FROM `%s` WHERE "%s" = "%s"' % (domain, key, value) response = client.select(SelectExpression = query) The variable key and value is input by user, what are the best way to escape…
Ryan
  • 10,041
  • 27
  • 91
  • 156
4
votes
3 answers

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
Senthil
  • 61
  • 1
  • 5
4
votes
1 answer

What's the best module to access SimpleDB in python?

I'm writing a python script to select, insert, update, and delete data in SimpleDB. I've been using the simpledb module written by sixapart so far, and it's working pretty well. I've found one potential bug/feature that is problematic for me when…
Ike Walker
  • 64,401
  • 14
  • 110
  • 109
4
votes
1 answer

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…
Justin Poliey
  • 16,289
  • 7
  • 37
  • 48
4
votes
2 answers

Choosing a database type

When would you use a bigtabe/simpledb database vs a Relational database?
Aaron Fischer
  • 20,853
  • 18
  • 75
  • 116
4
votes
1 answer

SimpleDB item name

I've just started on Amazon SimpleDB (first experience with noSQL), and while setting my first User domain, and adding the first item (with attributes id and name), i wondered what should the item name be? Like RDBMS ids: "1", "2", "3" (so i should…
H-H
  • 4,431
  • 6
  • 33
  • 41
4
votes
3 answers

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…
joelg
  • 83
  • 1
  • 9
4
votes
2 answers

Perl substr based on bytes

I'm using SimpleDB for my application. Everything goes well unless the limitation of one attribute is 1024 bytes. So for a long string I have to chop the string into chunks and save it. My problem is that sometimes my string contains unicode…
Minh Le
  • 1,145
  • 1
  • 12
  • 20
3
votes
3 answers

DynamoDB Database Design (Key-Value Store, noSQL)

I'm used to MySQL and now trying to grasp an understanding of how to use key value stores. What I have not seen are good noob like examples of database design and how you would insert and get information. Is this a correct representation of how you…
3
votes
1 answer

Amazon SimpleDB or DynamoDB

We are building a mobile app with a rails CMS to manage it. What our app look like? Every admin user of the app can set one private channel with very small amount of data - About 50 short strings. Users can then download the app and register few…