You can search (query) by a date. I'd index the date field, then just use out of box pagination.
And https://laraveldaily.com/eloquent-date-filtering-wheredate-and-other-methods/
Table Concept (Slimmed down for simplistics sake
Articles Table:
id
title
content
published_at
created_at
updated_at
Goal:
A user inputs a date (lets say 15 December 2019), we process a search to the server and send back the user 100 results, all articles published on the date, and whatever space is left we split between before and after the requested date.
I hope that makes sense, my head just can not grasp what I need, though I have a feeling it will be rather simple. Additionally I highly prefer to keep pagination working.
Any advise would be amazing. I am using an Article Model, basically standard practice and such.
Please or to participate in this conversation.