ryandotsmith
Using simple Hash tables with many items
For some people it's better to edit values in a single page, DynamoDB is able to do this, but the previous approach required one item per configuration, meaning one edit page per configuration.
With the following changes, the user is able to edit many configurations in a single page using a simple Hash table (with App as the hash key).
An example is included in the next image:
Interesting. What is the max number of attributes we can have in an item?
Excellent question, I haven't thought about that.
With a quick google search I found the next information:
- Every item collection in Amazon DynamoDB is subject to a maximum size limit of 10 gigabytes. For any distinct hash key value, the sum of the item sizes in the table plus the sum of the item sizes across all of that table's local secondary indexes must not exceed 10 GB...
- ItemSize in DynamoDB at StackOverflow.
It seems to be more than enough. Do you spot a caveat?
It doesn't look like there is a limit on the number of attributes, just a limit on the size of an item. The size limit on an item is 64KB. If we liberally assume an average of 100B per config then we can store 640 config variables per app. This seems like a pretty reasonable limit :)
Also, here is the link to the DynamoDB doc where I got the 64KB limit: http://docs.aws.amazon.com/amazondynamodb/latest/developerguide/Limits.html
Yep, you're right, thanks for the link!
Also, this approach can be used with a Hash and Range table, so if this feature makes sense, we could provide a notice on the readme with the limit of the size of the items and how to workaround with multiple tables using Hash and Range, what do you think?
