KPC
Kevin Powell - Community•16mo ago
Electronic

paginated

This a simple one just confused, in making paginated APIs how do I know where to add the next property so the frontend developer knows it has a next page...how do I check where the next is going to be a + 1 or it's going to be null, in a database,
4 Replies
ErickO
ErickO•16mo ago
is it a big db? and is the limit per page dynamic or static? cause you can simply COUNT the elements divide by the limit of results per request and send back that number as the total number of pages there are 
{
  "items": [...],
  "page": 1,
  "total": 100,
  "next": "https://api.example.com/items?page=2" // URL to next page of results
}
{
  "items": [...],
  "page": 1,
  "total": 100,
  "next": "https://api.example.com/items?page=2" // URL to next page of results
}
the response can look like that
Jochem
Jochem•16mo ago
If it's too large a dataset to COUNT, set your limit to per_page + 1, then pop the last result off
ErickO
ErickO•16mo ago
yeah that's why I asked the size of the db, COUNT can be slow if you have like...millions of rows but if you're not at that point COUNT + indexes is fine
Electronic
Electronic•16mo ago
Sorry I never replied, was off
Want results from more Discord servers?
Add your server
More Posts
Design tips for a thumb driven mobile layoutNeed some help getting this to look better in terms of appealing on the eyes and easy to navigate. Icss properties as global variables and can be used as a call back function?hello, are there any similar method in CSS that can be used as global variable like in JS? i feel lCSS doubtI want to put the glowing animation around the helmet. It is desktop size wallpaper. Can we bend Responsive designIs there a way to make it work? or start from fresh?Image doesn't fit in its parent div properlyI have a div(card) , Inside it i have two more divs 1. top div and 2. bottom div, inside top div i hFetching data from an API and putting them inside an array but it works differently in browser/IDE?It's React. Something weird happens. When I reload directly from the browser, it still logs an emptyCss Inheritance QuestionHi everyone! Asking this as a refresher for myself. I'm trying to set a font-size: 13px; on my h5'sIs there any way to keep overflow-x while changing overflow-y?My problem is caused by this issue: https://stackoverflow.com/questions/18135204/setting-overflow-yapply a class on based of scroll using only cssI have navbar with a width of 800px , when scroll happen I want that navbar take full width of the Can i have feedback on my projectI would like to have feedback on the layout, colour combination etc. Note i only did basic structur