The original title is: "Single-table DynamoDB design for a real-time game (rooms, rounds, leaderboards)"

Short summary

Author designed a single-table DynamoDB schema for a multiplayer game, storing all state (rooms, players, rounds, clicks) in one partition for minimal queries. Sort-key prefixes handle event lookups, a GSI powers leaderboards, and TTL auto-cleans ephemeral data. Trade-off: upfront key modeling, but predictable access patterns make it worthwhile.

• •Single-table design reduces round-trips by co-locating related entities in one partition
• •begins_with() on sort keys enables efficient queries like 'all clicks in round N'
• •GSI with score-based sorting handles multiple leaderboard variants (daily, weekly, per-room)

Generated with AI, which can make mistakes.