[Question] timeline query

[WiHHi-Z3-PuX]

Hi
great intro to DynamoDB!

a question:
how would you write a query/route for getting the latest photos from the users you follow, i.e. timeline?

I can think of a way with a batch get items, but that would probably become inefficient very quickly especially if the route supports pagination/gets page X number as an input and returns only the latest Y items as a page while skipping X * page size items.

[alexdebrie]

Hey @WiHHi-Z3-PuX, glad you liked it!

Great question. A timeline is a pretty complicated many-to-many setup (each timeline will have many posts, and a post can appear in many timelines), and it's probably not something you would want to calculate on the fly. You'd probably have some other system that is helping to pre-materialize it in some way to avoid on-demand calculation. Accordingly, I didn't include it here.

Hope that helps! Let me know if you have any other questions. Feel free to close if this answers it :)