Learn how to implement offset-based pagination in a Remix project using Prisma and SQL to manage large datasets efficiently. Explore techniques for setting limits and offsets per page, creating a user interface for pagination control, and adding navigation links for previous and next pages. Discover methods to improve code performance, handle pagination disparities, and incorporate accessibility features like aria-live elements. Follow along with practical examples and a coding challenge to enhance your skills in building scalable web applications.
Adding Offset Pagination to Our Remix Project With Prisma and SQL
Overview
Syllabus
- Intro
- Adding pagination to your database
- Setting a limit + offset per page
- Adding UI to control pagination responses
- Fixing some disparities in pagination
- Adding links to previous/next pages
- Improving code performance
- Challenge: Adding UI to show number of items per page
- Adding final touches to the code
- Adding aria-live element
- Wrap Up & What’s next
Taught by
Linode
Related Courses
-
Integrating PHP with Databases Course (How To)
-
Sending Data With Remix and Saving It With Prisma - Real World Database Application Building
-
API Reading and Updating - Sending Dynamic Route Parameters from Remix to Prisma
-
Creating a Full Stack App with Prisma & Remix
-
The Complete React Bootcamp 2023 (Updated)
-
Creating Sorting Lists with SQL and Prisma
