Adding offset pagination to our Remix project with Prisma and SQL
20What 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 https://www.youtube.com/watch?v=wqyHGQlZcws
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 Linode? 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/remix#usetransition
Subscribe to get notified of new episodes as they come out → https://www.youtube.com/linode?sub_confirmation=1
#Remix #Prisma #Postgres #Linode
Product: Linode, Akamai, Databases, Austin Gil