I am going to write an application that uses QT4 (with C++ or python it isnt important in that moment). One of functionality is "Showing all items in database".

One item has a Title, author, description and photo (constant size)

And there could be very many items. Let's say 400. There won't be enough space to show'em all at once time. One row will have 200px, so i need at most 4 for once time.

How to paginate them? I have no idea. I can use limit and offset in SQL queries, but how to tell window: "that's 5th page"?

Any solutions?