Support for Pagination in Database Posts

[matheusgomes28]

Add support for pagination in posts returned from db.GetPosts(...). This way, we can make the number of displayed posts in the index page configurable.

This can be achieved quite easily by adding LIMIT and OFFSET to the query, but we would need to capture the current offset in perhaps a GET url parameter.

[ali-assar]

Hi. I understood the issue and Here’s a proposed solution:

• Modify the GetPosts function in the database package to take two additional parameters like this: func (db SqlDatabase) GetPosts(limit int, offset int) (all_posts []common.Post, err error) { ...}
• Then in the function that handles requests to the page where posts are displayed, you can use the http.Request object to get the values of limit and offset from the URL parameters.

So I think, I can handle it.

[matheusgomes28]

@Ali-Assar Sounds like a solid plan mate!

That's along the lines of what I was thinking about. Feel free to send the PR my way whenever you have time to complete it, happy to review it with you 😆

[matheusgomes28]

I think that usually, websites have like a URL parameter to indicate which page it is, then you can deduce what limit and offset value you want to serve.

for more info on this for gin, take a look at the query parameters documentation.

To add some stuff to your plan:

• Add a new handler for something like /page/:num request
• Perhaps refactor the current handler that's currently handling / so you can reuse in the other page/:num handlers. If you think about it, the index is just /page/0 or something.

downside is that there is a cache on top of the / handler, but let me know if you are struggling because I can come in and help. For now, if you just want to add a separate handler for /page/:num, that would be great

[matheusgomes28]

Closed with #50