What I learned From Merging Two DynamodDB Tables
Introduction We had OrderRecord and TrackingRecord in separate tables. Here's what happened when we put them together, and what I wish I'd known beforehand. The Starting Point Our e-commerce system had two tables that were constantly talking to each other: // OrderRecord table { PK: "order_12345", customerId: "customer_456", totalAmount: 99.99, orderStatus: "confirmed" } // TrackingRecord table { PK: "tracking_67890", orderId: "order_12345", // Always needed to link back carrier: "UPS", trackingNumber: "1Z999AA1234567890", deliveryStatus: "in_transit" } Every time we showed order details to customers, we made two API calls. It worked, but it felt wasteful. ...