Building a Car Trader App #5: Pagination with filters for the list of cars

In this video, we will create the paginated and filtered list of cars. We will create a getPaginatedCars function that will also be used in the next video API call. Inside getPaginatedCars we will create a SQL query to filter our cars, using the filters we have done in the previous video on the search page. Then we will use SQLite’s LIMIT and OFFSET to paginate our cars. When our query is finalized, we will call it inside getServerSideProps in order to display our list of cars. In this video the list display will be done using JSON, in the next video, we will style it using material (@material-ui/core) cards. We will also touch the concept of shallow rendering in Link component - briefly. We will use the Pagination component from @material-ui/lab to have pagination buttons. I ... #BrunoAntunesPT # # #Nextjs_Tutorial #Nextjs_for_beginners # #React_nextjs # #nextjs_typescript #car_trader_app 20200519 L9c1b2D28BQ