Dynobase (@dynobase) header
Dynobase (@dynobase) profile picture

Professional GUI Client for DynamoDB https://teapawt.net/t.co/nqS5b8GVKr

Joined January 2020
Photo by Dynobase (@dynobase)Photo by Dynobase (@dynobase)Photo by Dynobase (@dynobase)Photo by Dynobase (@dynobase)Photo by Dynobase (@dynobase)Photo by Dynobase (@dynobase)Photo by Dynobase (@dynobase)Photo by Dynobase (@dynobase)Photo by Dynobase (@dynobase)Photo by Dynobase (@dynobase)
Stages of trusting DynamoDB BatchWriteItem: 1. Send 25 items 2. Get a 200 back 3. Assume all 25 landed 4. Rows go missing under load 5. Find UnprocessedItems 6. Retry them with backoff A successful batch call doesn't mean every item was written. Which stage are you at?
1
112
Unpopular opinion: a DynamoDB Scan doesn't belong in a request path. It reads the whole table, 1 MB per call, and you pay for every item read before any filter runs. If a user is waiting on it, you need a Query, maybe on a GSI. Keep Scan for exports, backfills and admin tools.
87
Before you wire a Lambda to a DynamoDB stream in prod: 1. Pick the view type you need (KEYS_ONLY up to NEW_AND_OLD_IMAGES) 2. Make the handler idempotent. Retries happen 3. Cap retries and add an on-failure destination 4. Alert on iterator age. Records expire after 24h
2
83
Unpopular opinion: on-demand should be the default capacity mode for most new DynamoDB tables. You don't know your traffic yet. A wrong provisioned guess either throttles or wastes money. Measure real usage first. Switch to provisioned once the load is steady and predictable.
2
150
What actually happens when you call UpdateItem in DynamoDB? 🧵 Five steps, and two of them surprise most people.
1
1
121
5. Every index whose keys or projected attributes changed gets written too, and those writes cost capacity as well. If Streams are on, the change is recorded there. Tip: ReturnValues UPDATED_NEW hands you the result without a second read.
1
12
Which of these bit you first? In Dynobase, the Operation Builder shows the generated update code and conditions before you run the write.
11
Before you import a CSV into a prod DynamoDB table: 1. Check every row has the key attributes 2. Map types (CSV has none) 3. Decide what a duplicate key does 4. Pace writes for live traffic Dynobase's import wizard previews types, key coverage and conflict handling first.
1
2
95
What's the first DynamoDB habit you break when a new teammate joins? Mine: assuming UpdateItem only updates existing items. Without a condition, it creates the item if the key is missing. What's yours?
84
Unpopular opinion: every production DynamoDB table should have deletion protection on. It's free. It's one setting. And it turns "oops, wrong account" into an error message instead of an incident. A prod table shouldn't be one API call away from gone.
76
35 days. That's the longest window DynamoDB point-in-time recovery can restore from, down to the second. The catch: PITR is off until you turn it on, and a restore always lands in a new table. Enable it before the bad deploy, not after.
1
106
Stages of DynamoDB "we'll fix the key later": 1. Ship with a busy-friendly PK 2. Traffic grows 3. One hot key 4. Throttles in prod 5. "We'll shard next sprint" 6. Next sprint ships features instead Which stage are you stuck in?
2
157
Myth: you can add a local secondary index later. You can't. LSIs are chosen at CreateTable. After that, the only option is a new table (or a GSI, which is a different tool). Need another sort-key pattern on an existing table? Plan a GSI — or migrate.
1
69
Safer order when adding a DynamoDB GSI: 1. Confirm the Query pattern needs it 2. Create the GSI (existing items start backfilling) 3. Wait until IndexStatus is ACTIVE 4. Only then route traffic to it CREATING ≠ ready. Queries on a still-building index fail or miss items.
1
111
10 GB. Max size of one DynamoDB partition that holds a local secondary index. An LSI lives on the same partition as the base item. Grow past ~10 GB and writes that enlarge it start failing. Watch partition size, not just RCU/WCU.
1
68
Myth: ConsistentRead on a Scan makes the whole table strongly consistent. Wrong. It only applies within each partition page. Across pages you can still see mixed old and new versions. Need a true snapshot? Use Export or PITR — not ConsistentRead Scan.
61