Questions tagged [amazon-dynamodb]

Amazon DynamoDB is a proprietary closed-source cloudnative key-value and document database optimized for horizontal scaling. It's a fully managed, multiregion, multimaster database with built-in security, backup and restore, and in-memory caching for internet-scale applications. DynamoDB is hosted on AWS, but also has a local deployment option just for development and functional testing. Used on amazon.com.

Amazon DynamoDB is a fully managed NoSQL database service that provides fast and predictable performance with seamless scalability. It enables customers to offload the administrative burdens of operating and scaling distributed databases to AWS so they don’t have to worry about hardware provisioning, setup and configuration, replication, software patching, or cluster scaling.

With a few clicks in the AWS Management Console or by making use of the Amazon Dynamo DB API, customers can launch a new Amazon DynamoDB database table, scale up or down their request capacity for the table without downtime or performance degradation, and gain visibility into resource utilization and performance metrics.


Related tags :

10806 questions
255
votes
4 answers

What is Hash and Range Primary Key?

I am not able to understand what Range / primary key is here in the docs on Working with Tables and Data in DynamoDB How does it work? What do they mean by "unordered hash index on the hash attribute and a sorted range index on the range attribute"?
mannuscript
  • 3,812
  • 5
  • 19
  • 25
210
votes
9 answers

Amazon SimpleDB vs Amazon DynamoDB

I have some basic understanding what Amazon SimpleDB is, but according to the Amazon DynamoDB description it seems to be almost the same: a NoSQL Key-value store service. Can someone simply explain the main differences between them and tell in which…
182
votes
8 answers

DynamoDB vs MongoDB NoSQL

I'm trying to figure it out what can I use for a future project, we plan to store from about 500k records per month in the first year and maybe more for the next years this is a vertical application so there's no need to use a database for this,…
pedrommuller
  • 14,865
  • 9
  • 65
  • 115
147
votes
7 answers

Difference between local and global indexes in DynamoDB

I'm curious about these two secondary indexes and differences between them. It is hard to imagine how this looks like. And I think, this will help more people than just me.
Michael Czolko
  • 2,103
  • 2
  • 11
  • 20
141
votes
4 answers

Number of attributes in key schema must match the number of attributes defined in attribute definitions

I’m trying to create a simple table using DynamoDB JavaScript shell and I’m getting this exception: { "message": "The number of attributes in key schema must match the number of attributes defined in attribute definitions.", "code":…
NAbbas
  • 1,433
  • 2
  • 8
  • 6
127
votes
7 answers

What is the recommended way to delete a large number of items from DynamoDB?

I'm writing a simple logging service in DynamoDB. I have a logs table that is keyed by a user_id hash and a timestamp (Unix epoch int) range. When a user of the service terminates their account, I need to delete all items in the table, regardless of…
Tyler
  • 2,419
  • 4
  • 20
  • 29
119
votes
4 answers

AWS MySQL RDS vs AWS DynamoDB

I've been using MySQL for a fair while now and I'm comfortable with its structure & SQL Queries etc. Currently building a new system in AWS and I've been looking at DynamoDB. Currently I only know a little about it. Is one better then the other?…
Adam
  • 17,063
  • 33
  • 111
  • 184
118
votes
8 answers

Querying DynamoDB by date

I'm coming from a relational database background and trying to work with amazon's DynamoDB I have a table with a hash key "DataID" and a range "CreatedAt" and a bunch of items in it. I'm trying to get all the items that were created after a specific…
applechief
  • 5,515
  • 11
  • 45
  • 66
108
votes
4 answers

What data type should be use for timestamp in DynamoDB?

I am new to DynamoDB. I wish to create a table which using DeviceID as the hash key, Timestamp as my range key and some data. { DeviceID: 123, Timestamp: "2016-11-11T17:21:07.5272333Z", X: 12, Y: 35 } In SQL, we can use datetime type for Timestamp,…
Dennis
  • 2,860
  • 4
  • 23
  • 37
93
votes
5 answers

How to use auto increment for primary key id in dynamodb

I am new to dynamodb. I want to auto increment id value when I use putitem with dynamodb. Is possible to do that?
pranay
  • 1,059
  • 1
  • 8
  • 7
91
votes
7 answers

Is it possible to ORDER results with query or scan in DynamoDB?

Is it possible to ORDER results with Query or Scan API in DynamoDB? I need to know if DynamoDB has something like ORDER BY 'field' from SQL queries? Thanks.
Samuel Negru
  • 1,011
  • 1
  • 7
  • 3
89
votes
3 answers

Difference between DynamoDb PutItem vs UpdateItem?

Based on DynamoDb documentation why would anyone use updateItem instead of putItem? PutItem - Writes a single item to a table. If an item with the same primary key exists in the table, the operation replaces the item. For calculating provisioned…
Sindhu
  • 1,746
  • 1
  • 17
  • 16
89
votes
5 answers

What is the difference between scan and query in dynamodb? When use scan / query?

A query operation as specified in DynamoDb documentation: A query operation searches only primary key attribute values and supports a subset of comparison operators on key attribute values to refine the search process. and the scan operation: A…
samson
  • 1,279
  • 2
  • 10
  • 19
89
votes
13 answers

How to get item count from DynamoDB?

I want to know item count with DynamoDB querying. I can querying for DynamoDB, but I only want to know 'total count of item'. For example, 'SELECT COUNT(*) FROM ... WHERE ...' in MySQL $result = $aws->query(array( 'TableName' => 'game_table', …
sam lee
  • 903
  • 1
  • 6
  • 6
86
votes
4 answers

How to Add a Column in DynamoDB

Is there a way to add a new column to existing table in DynamoDB in Amazon's AWS? Google didn't help, UpdateTable Query in http://docs.aws.amazon.com/cli/latest/reference/dynamodb/update-table.html?highlight=update%20table doesn't have any…
Arun Selva Kumar
  • 2,172
  • 2
  • 16
  • 25
1
2 3
99 100