AWS — DynamoDB

What is DynamoDB?

Fully managed NoSQL database service.

Create table

aws dynamodb create-table \
  --table-name Users \
  --attribute-definitions \
    AttributeName=id,AttributeType=N \
  --key-schema AttributeName=id,KeyType=HASH \
  --billing-mode PAY_PER_REQUEST

Put item

aws dynamodb put-item \
  --table-name Users \
  --item '{"id": {"N": "1"}, "name": {"S": "John"}, "email": {"S": "john@example.com"}}'

Get item

aws dynamodb get-item \
  --table-name Users \
  --key '{"id": {"N": "1"}}'

Query

aws dynamodb query \
  --table-name Users \
  --key-condition-expression "id = :id" \
  --expression-attribute-values '{":id": {"N": "1"}}'

Scan

aws dynamodb scan --table-name Users

Update item

aws dynamodb update-item \
  --table-name Users \
  --key '{"id": {"N": "1"}}' \
  --update-expression "SET email = :email" \
  --expression-attribute-values '{":email": {"S": "new@example.com"}}'

Delete item

aws dynamodb delete-item \
  --table-name Users \
  --key '{"id": {"N": "1"}}'

Global Secondary Index

aws dynamodb update-table \
  --table-name Users \
  --attribute-definitions \
    AttributeName=email,AttributeType=S \
  --global-secondary-index-updates \
    "[{\"Create\":{\"IndexName\":\"email-index\",\"KeySchema\":[{\"AttributeName\":\"email\",\"KeyType\":\"HASH\"}],\"Projection\":{\"ProjectionType\":\"ALL\"}}}]"

Best practices

1. Design for uniform access
2. Use sparse indexes
3. Enable auto scaling
4. Use DAX for caching

Mini Practice

1. Create a table
2. CRUD operations
3. Query with indexes
4. Enable auto scaling

Up Next

Continue with SQS - Message Queues.