🔧 [20 Days of DynamoDB] Day 11 - Using pagination with Query API
Nachrichtenbereich: 🔧 Programmierung
🔗 Quelle: dev.to
Posted: 22/Jan/2024
The Query
API returns the result set size to 1 MB
. Use ExclusiveStartKey
and LastEvaluatedKey
elements to paginate over large result sets. You can also reduce page size by limiting the number of items in the result set, with the Limit
parameter of the Query
operation.
Here is an example:
func paginatedQuery(searchCriteria string, pageSize int32) {
currPage := 1
var exclusiveStartKey map[string]types.AttributeValue
for {
resp, _ := client.Query(context.Background(), &dynamodb.QueryInput{
TableName: aws.String(tableName),
KeyConditionExpression: aws.String("ForumName = :name"),
ExpressionAttributeValues: map[string]types.AttributeValue{
":name": &types.AttributeValueMemberS{Value: searchCriteria},
},
Limit: aws.Int32(pageSize),
ExclusiveStartKey: exclusiveStartKey,
})
if resp.LastEvaluatedKey == nil {
return
}
currPage++
exclusiveStartKey = resp.LastEvaluatedKey
}
}
Recommended reading - Query Pagination
...
🔧 [20 Days of DynamoDB] Day 7 - DeleteItem API
📈 35.65 Punkte
🔧 Programmierung
🔧 DynamoDB Basic - Part 1: Introduction DynamoDB
📈 34.35 Punkte
🔧 Programmierung
🔧 CodeSOD: Query Query Query
📈 31.92 Punkte
🔧 Programmierung
🐧 DynamoDB Query Examples
📈 27.81 Punkte
🐧 Linux Tipps
🔧 20 Days of DynamoDB
📈 25.36 Punkte
🔧 Programmierung
🔧 20 Days of DynamoDB
📈 25.36 Punkte
🔧 Programmierung
🔧 Customizing API Resource Pagination Structure
📈 25.26 Punkte
🔧 Programmierung
🔧 Day 21. Pagination
📈 24.02 Punkte
🔧 Programmierung
🔧 API Gateway, Lambda, DynamoDB and Rust
📈 22.95 Punkte
🔧 Programmierung