3 ms·

DynamoDB is amazing, but not very flexible once you have designed your database. No abstraction layer will allow you to run queries ad-hoc in a performant way.

• whalesalad 4y ago
  It’s true. 400kb max item size, too. 1mb max query size I believe. Good luck grabbing a shit load of data at once without a parallel scan. Dynamo is a precision tool and it’s great at those specific workloads but it’s not a one size fits all by any means.
  • deleted 4y ago
    [deleted]
  • shepherdjerred 4y ago
    400kb is the max item size, the pattern to get around that is to store objects in S3 and URLs/keys to those objects in DDB
• eatonphil 4y ago
  > No abstraction layer will allow you to run queries ad-hoc in a performant way. Depends on the size of the data. Run analytics queries (i.e. things that return summary data not all rows) on 10GB of data through clickhouse or duckdb or datafusion and they'll generally return in milliseconds.
  • nightpool 4y ago
    What does this have to do with DynamoDB? The point is that once you've gotten your data into DynamoDB, you're strongly limited in how you can use it until you load it into something else.
    • eatonphil 4y ago
      I didn't see an obvious connection between the two sentences.