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.

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!
The code for this project is available here.
Check out the Remix Transition docs here.
Subscribe to get notified of new episodes as they come out.

#Remix #Prisma #Postgres #Linode
Product: Linode, Akamai, Databases, Austin Gil

Developer Tools