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
0
votes
1 answer

Amazon SimpleDB cache problem

I'm experimenting with Amazon SimpleDB (using Rick Helms' PHP API) and I've noticed that the updates are not in real time. I mean, if in the same page I contact the service to delete and item and the retrieve the items list, the deleted item is…
pistacchio
  • 56,889
  • 107
  • 278
  • 420
0
votes
1 answer

Encoding in SimpleDB for batch_put_attributes

I'm using the AWS SDK for python to interact with SimpleDB. client = boto3.client('sdb') example = [ {'Name': 'test1', 'Attributes': [ {'Name': 'speaker', 'Value': 'DIEGO BASSANTE'}]}, {'Name': 'test2', 'Attributes': [ …
Edwin
  • 836
  • 7
  • 17
0
votes
0 answers

AWS SimpleDB getAttributes consistency

The docs for the Java SDK for SimpleDB say the following regarding the getAttributes(GetAttributesRequest request) operation: If the item does not exist on the replica that was accessed for this operation, an empty set is returned. The system does…
RTF
  • 6,214
  • 12
  • 64
  • 132
0
votes
1 answer

How best to map this structure onto amazon SimpleDB

So simpledb has a kind of spreadsheet data model. I have an app that simply needs to store keys against values. Except that a single key can have multiple values. There will be multiple clients. Each client has an id with it's own set of keys. I'd…
hookenz
  • 36,432
  • 45
  • 177
  • 286
0
votes
2 answers

SimpleDB parallelism

There is a comment in the SimpleDB documentation that states basically that if you need more parallelism then you should use multiple domains. This leads me to this question. Does SimpleDB serialize all of it's requests even they come from multiple…
hookenz
  • 36,432
  • 45
  • 177
  • 286
0
votes
1 answer

sql database query from amazon s3 website

ok, basically what i would like to do is query a database to build a simple table on my website. i'm using amazon tools for everything. the database is built in simpledb and works fine. however, making queries from my index.html requires php, which…
0
votes
3 answers

how can i give the order by in s3 database

if(!$_GET){ echo "{'success':false, 'error':'No query parameters submitted'}"; return; } // 1. Include the SimpleDB class if it does not exist if (!class_exists('SimpleDB'))require_once('sdb.php'); // 2. Set awsAccessKey and awsSecretKey…
XMen
  • 29,384
  • 41
  • 99
  • 151
0
votes
0 answers

How to migrate data from Parse to Amazon Simple DB

i'm trying to migrate my database from Parse to Amazon Simple DB. I've exported data from Parse. Right now, i've JSON file for every Parse' table. I'm not sure how to import it on Simple DB. How to migrate data from Parse to Simple DB?. Note: I did…
Fayza Nawaz
  • 2,256
  • 3
  • 26
  • 61
0
votes
1 answer

Amazon SimpleDB: Response messages don't agree with the request parameters

I'm making a simple high scores database for an iPhone game using Amazon's SimpleDB and am running into some strange issues where SimpleDB's response messages don't seem to line up with the requests I'm sending or even the state of the data on the…
Mattia
  • 2,251
  • 1
  • 22
  • 27
0
votes
2 answers

Time to live for SimpleDB or DynamoDB

Our requirement is very simple, we want to store GPS location for sensors which should not be older than a couple of days. The total granularity of data would be max around a minute or so. Since the total number of sensors could exceed a billion,…
Ouroboros
  • 1,432
  • 1
  • 19
  • 41
0
votes
1 answer

AWS DynamoDB or SimpleDB: "SELECT * FROM posts ORDER BY date LIMIT 10"

I'm hoping to design a serverless backend with AWS. I'm using RDS as my primary datastore, but I'd like to move heavily-queried data (lets call these records "posts") to either DynamoDB or SimpleDB because of limitations on the number of concurrent…
Rob
  • 852
  • 1
  • 9
  • 22
0
votes
1 answer

AWS SimpleDB Ruby v1 SDK delete method not working

I'm trying to delete a bunch of records in an AWS SimpleDB domain using the delete method of the Item class with the AWS Ruby SDK (v1) e.g. expected_total = # fetched using a count(*) query actually_deleted = 0 query = "select * from MyDomain where…
RTF
  • 6,214
  • 12
  • 64
  • 132
0
votes
1 answer

Remove "Column" Name / Attribute in SimpleDB

I have a table (Domain) in AWS Simple DB and I would like to remove a single column from the "schema". Was this possible to do somehow without recreating the whole table (Domain)? Thanks
James Marino
  • 668
  • 1
  • 9
  • 25
0
votes
1 answer

Removing items from SimpleDB without knowing the ItemName?

I have a domain in Simple DB that looks like this: (ItemName | Attribute 1 | Attribute 2 | foo | X | Y | bar | X | Z | I'd like to be able to delete everything from the domain that matches a…
0
votes
0 answers

Creating DBs on the fly for all my users

I'm building a Rails app in which I'd like to provide every user each with their own database to work with. At the moment I'm thinking SimpleDB due to its compatibility with JSON, low maintenance, and compatibility with AWS. However, I did notice…
sonobenissimo
  • 191
  • 4
  • 14