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
You might also like…
-
Building and Deploying a Django App | Part 1 – Setting Up Your Environment
In this video, we will cover the first step of the process: setting up your development environment by installing Django. -
How to Install Cloudron on Linode with LanaLux | Self Host a Marketplace of Open Source Apps
Cloudron is a free and open source platform that makes it easy to install, manage and secure web apps on a server. -
Build a Blogging Machine That Generates Its own Content Using AI | Code With Harry Tutorial
In this video, @CodeWithHarry explains how to create a blog with OpenAI and ChatGPT that generates content based on the topic of your choice. -
How to Deploy a Static Site using Hugo Linode Tutorial with TechHut
Hugo is written in Go and is known for being extremely fast to compile websites, even very large ones. Hugo is well supported.