Adding offset pagination to our Remix project with Prisma and SQL
What happens when our list of pets on the database gets way too long? To prevent having too much data on the page or slowing down our requests, we’ll add offset-based pagination to our Remix project. In this video, we learn how to accomplish that in SQL, and implement it with Prisma. The first video in this series is available here • Build A Pet Management System With Re...
Chapters:
0:00 - Intro
0:19 - Adding pagination to your database
1:22 - Setting a limit + offset per page
8:00 - Adding UI to control pagination responses
11:14 - Fixing some disparities in pagination
12:56 - Adding links to previous/next pages
20:00 - Improving code performance
22:00 - Challenge: Adding UI to show number of items per page
22:55 - Adding final touches to the code
25:45 - Adding aria-live element
26:42 - Wrap Up & What’s next
New to Cloud Computing? Get started here with a $100 credit → https://www.linode.com/akatube
The code for this project is available here → https://github.com/AustinGil/npm
Check out the Remix Transition docs here → https://remix.run/docs/en/v1/api/remi...
Subscribe to get notified of new episodes as they come out → https://www.youtube.com/linode?sub_co...
#Remix #Prisma #Postgres #Linode
Product: Linode, Akamai, Databases, Austin Gil
Watch video Adding offset pagination to our Remix project with Prisma and SQL online without registration, duration hours minute second in high quality. This video was added by user Akamai Developer 02 December 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 3,888 once and liked it 68 people.