amazon dynamoDB or MySQL for storing large arrays inside each row
        Posted  
        
            by 
                Logan Besecker
            
        on Server Fault
        
        See other posts from Server Fault
        
            or by Logan Besecker
        
        
        
        Published on 2012-07-09T01:03:37Z
        Indexed on 
            2012/07/09
            3:17 UTC
        
        
        Read the original article
        Hit count: 686
        
I am trying to decide which database I should use for an application I'm making. I was leaning toward dynamoDB because of its scalability, but then I read in the documentation which said:
there is a limit of 64 KB on the item size
although it looks like MySQL has a similar restriction documented here
This application will be storing a lot of data in two arrays, which could contain upwards of 10,000-100,000 strings in each. I estimate that these strings will each be somewhere around 20 characters long, so each element of the array will be around 40bytes and each array could be around 4MB.
Given this predicament, what database on amazon AWS would you use; or how would you get around the limit of size per row?
Thanks in advance,
Logan Besecker
© Server Fault or respective owner