Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Adding offset pagination to our Remix project with Prisma and SQL

Akamai Developer
1.04M subscribers
<__slot-el>
<__slot-el>
4K views 2 years ago #Linode #Postgres #Remix
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 ...more
...more
Adding offset pagination to our Remix project with Prisma and SQL
70Likes
4,008Views
2022Dec 2
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

Follow along using the transcript.

Akamai Developer

1.04M subscribers