Hire Expert
DynamoDB Developers

import { DynamoDBClient } from '@aws-sdk/client-dynamodb';
import { DynamoDBDocumentClient, PutCommand, QueryCommand } from '@aws-sdk/lib-dynamodb';

const client = DynamoDBDocumentClient.from(new DynamoDBClient({ region: 'ap-south-1' }));

// Single-table design: user and their orders in one table
await client.send(new PutCommand({
  TableName: 'AppTable',
  Item: {
    PK: 'USER#user-123',
    SK: 'ORDER#2024-01-15#order-456',
    type: 'order',
    amount: 299.99,
    status: 'pending',
    ttl: Math.floor(Date.now() / 1000) + 86400 * 90,
  },
  ConditionExpression: 'attribute_not_exists(PK)',
}));

// Query all orders for a user
const { Items } = await client.send(new QueryCommand({
  TableName: 'AppTable',
  KeyConditionExpression: 'PK = :pk AND begins_with(SK, :prefix)',
  ExpressionAttributeValues: { ':pk': 'USER#user-123', ':prefix': 'ORDER#' },
}));