title: Options for paging and sorting a DynamoDB result set?
body: <p>I'm starting on a new project and am going to be using DynamoDB as the main data source. A lot of what it does works perfectly for the needs, with a couple exceptions.</p>
  
  <p>Those are the sorting and paginating needs of the UI. Users can sort the data by anywhere from 8-10 different columns, and a result set of 20-30k+ rows should be paginated over.</p>
  
  <p>From what I can tell of DynamoDB, the only way to do sorting by all those columns would be to expose that many sort keys through a variety of additional indexes, and that seems like a misuse of those concepts. If I'm not going to sort the data with DynamoDb queries, I can't paginate there either.</p>
  
  <p>So my question is, what's the quickest way once I have the data to paginate &amp; sort? Should I move the result set into Aurora and then sort &amp; page with SQL? I've thought about exporting to S3 and then utilizing something like Athena to page &amp; sort, but that tool really seems to be geared to much larger datasets than this. What are other options?</p>