Resources

North Central Cascades

A curated list of resources that you might find helpful.

1. Tools

NoSQL Workbench - some weirdness, but the best option for data modeling

Dynobase - some people still like this for managing tables - sadly poor for data modeling

Kona - a new option - please check it out and provide feedback to the developer

Item Size Calculator - web tool

Item Size Calculator - CLI

ddb-calc - this item size tool from the very awesome Lee Hannigan

dynamodb-shell - amazing stuff from Amrith

2. Documentation

Amazon DynamoDB Developer Guide

Amazon DynamoDB API Reference

3. Quick demo repositories

DynamoDB Transactions Basics

4. Pete’s youtube playlist

Pete keeps a playlist of some of his favorite DynamoDB, general AWS, and general databases videos on youtube - check them out!

5. Various blogs

Monitoring Amazon DynamoDB for operational awareness

Backfilling an Amazon DynamoDB Time to Live (TTL) attribute with Amazon EMR

Backfilling an Amazon DynamoDB Time to Live attribute using Amazon EMR: Part 2

Partitioning Pooled Multi-Tenant SaaS Data with Amazon DynamoDB

Safely reduce the cost of your unused Amazon DynamoDB tables using on-demand mode

Build faster with Amazon DynamoDB and PartiQL: SQL-compatible operations

Use parallelism to optimize querying large amounts of data in Amazon DynamoDB

Accelerate Amazon DynamoDB data access in AWS Glue jobs using the new AWS Glue DynamoDB Export connector

Use vertical partitioning to scale data efficiently in Amazon DynamoDB

Scaling DynamoDB: How partitions, hot keys, and split for heat impact performance (Part 1: Loading)

Scaling DynamoDB: How partitions, hot keys, and split for heat impact performance (Part 2: Querying)

Scaling DynamoDB: How partitions, hot keys, and split for heat impact performance (Part 3: Summary and best practices)

Calculate Amazon DynamoDB reserved capacity recommendations to optimize costs

Implement vertical partitioning in Amazon DynamoDB using AWS Glue

Understanding Amazon DynamoDB latency

Optimize costs by scheduling provisioned capacity for Amazon DynamoDB

Working with JSON data in Amazon DynamoDB

Rate limited bulk operations in DynamoDB Shell

Generate a distinct set of partition keys for an Amazon DynamoDB table efficiently

How to store historical geospatial data in AWS for quick retrieval

Exploring Amazon DynamoDB SDK clients

Build aggregations for Amazon DynamoDB tables using Amazon DynamoDB Streams

Archive to cold storage with Amazon DynamoDB

Visualize Amazon DynamoDB insights in Amazon QuickSight using the Amazon Athena DynamoDB connector and AWS Glue

Database caching: Outdoing DAX with the serverless solution DynamoDB deserves

Plenty of good content from Alex DeBrie!!

6. Books

The DynamoDB Book is a great resource for gaining some background context on DynamoDB and offers a wealth of useful techniques. Don’t take them too far and fall into the “Exactly One Table Design” trap, but there is a ton of value here from Pete’s friend and fellow database geek Alex DeBrie. This book is highly recommended!