Pagination is the process of dividing a document into discrete pages, either electronic pages or printed pages. Today printed pages are usually produced by outputting an electronic file to a printing device, such as a desktop printer or a modern printing press. These electronic files may for example be Microsoft Word, PDF or QXD files. They will usually already incorporate the instructions for pagination, among other formatting instructions. Pagination encompasses rules and algorithms for deciding where page breaks will fall, which depend partly on cultural considerations about which content belongs on the same page: for example one may try to avoid widows and orphans. Some systems are more sophisticated than others in this respect. Before the rise of information technology (IT), pagination was a manual process: all pagination was decided by a human. Today, most pagination is performed by machines, although humans often override particular decisions (e.g. by inserting a hard page break).
API Pagination: Making Billions of Products Scrolling Possible
Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: https://bit.ly/bbg-social
Animation tools: Adobe Illustrator and After Effects.
Checkout our bestselling System Design Interview books:
Volume 1: https://amzn.to/3Ou7gkd
Volume 2: https://amzn.to/3HqGozy
The digital version of System Design Interview books: https://bit.ly/3mlDSk9
ABOUT US:
Covering topics and trends in large-scale system design, from the authors of the best-selling System Design Interview series.
published: 20 Nov 2024
Pagination in MySQL - offset vs. cursor
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
Blog post on pagination: https://planetscale.com/blog/mysql-pagination.
Video on deferred joins: https://planetscale.com/learn/courses/mysql-for-developers/examples/deferred-joins.
Article on deferred joins: https://aaronfrancis.com/2022/efficient-pagination-using-deferred-joins.
——————————————————
00:00 Intro
00:12 How to pronounce paginate
00:30 The two pagination methods
00:54 We have bosses
01:25 Select * from people
01:45 Deterministic ordering
03:20 Limit/offset pagination
05:17 Shifting records in offset pagination
06:12 Cursor based pagination
08:13 Ordering by two columns
09:23 Cursor pagination drawbacks
09:53 Cursor pagination advantages
10:50 Summary of differences
——————————————————
💬 Follo...
published: 07 Sep 2023
API Design: What is Pagination?
#apidevelopment #pagination #softwaredevelopment
In API design, pagination is a technique used to manage and limit the amount of data returned by an API endpoint. When dealing with large sets of data, it's not efficient or practical to return the entire dataset in a single response. Pagination allows the API to provide a subset or "page" of the data, making it more manageable for clients to retrieve and process.
#software #engineering #datascience #datascientist #api
published: 22 Feb 2024
Simple Frontend Pagination | React
In this video we will implement some custom pagination in React to get a certain number of fetched posts per page. We will be using the useState and useEffect hooks as well.
Code:
https://github.com/bradtraversy/simple_react_pagination
Sponsor: Freelancer Bundle (Use "brad25" for 25% off)
https://studywebdevelopment.com/freelancing.html
💖 Become a Patron: Show support & get perks!
http://www.patreon.com/traversymedia
Website & Udemy Courses
http://www.traversymedia.com
Follow Traversy Media:
https://www.facebook.com/traversymedia
https://www.twitter.com/traversymedia
https://www.instagram.com/traversymedia
published: 23 Jun 2019
JavaScript Pagination in ~10 Minutes (Super EASY!!)
Improve your website's user experience by learning Pagination in JavaScript. This video takes you step-by-step through the process, using a dummy JSON API for products as an example. Learn to avoid loading too much data at once, and instead deliver a smoother, faster browsing experience. We'll explore a few different way to handle pagination: client-side, statically generated pages, and server side rendered pages.
Learn Astro 3.0 - https://astrocourse.dev/
*** Resources ***
Diagraming with Eraser - https://app.eraser.io
Dummy Data API - https://dummyjson.com/docs/products
**DISCORD**
Join the Learn Build Teach Discord Server 💬 - https://discord.gg/vM2bagU
**STAY IN TOUCH 👋**
Newsletter 🗞 - https://www.jamesqquick.com/newsletter
Follow me on Twitter 🐦 - https://www.twitter.com/jamesqqu...
published: 24 Aug 2023
Learn CSS pagination in 8 minutes! 🕮
#CSS #tutorial #course
CSS HTML pagination tutorial example explained
published: 21 Sep 2023
How to design API that display and filter through millions of products.REST API Filters & Pagination
We are very glad to start the REST APIs made easy course with the very first video on fundamentals of REST APIs, HTTP Methods, taxonomy around REST APIs etc. We hope that you get some value out of this course and these concepts help you thrive in your jobs, interviews and help you become better software engineers every day. Here are few links that you might want to refer before or during the course:
We hope that you get some value out of this course and these concepts help you thrive in your jobs, interviews and help you become better software engineers every day.
More on the topic:
✒https://developer.mozilla.org/en-US/docs/Glossary/REST
✒https://github.com/microsoft/api-guidelines
Previous videos to catch up on:
✒What is an API - https://youtu.be/dpcILJ8BTzU
✒REST Standards - https:/...
published: 09 Oct 2021
Web API Pagination | Offset-based vs Cursor-based
Web API pagination is crucial for building scalable APIs. There are 2 different pagination standards that you can use. It's offset-based pagination and cursor-based pagination, sometimes referred to as continuation token based pagination. It's important that you understand how these standards work and pick the right one because it's not a one size fits all thing. In this video, I give you all the details you need to pick the right one for your use case.
#WebAPIDesign #Pagination
Timecodes
0:00 - API pagination intro
3:10 - Offset-based pagination
6:50 - Cursor-based pagination
9:57 - Comparison
published: 28 Mar 2021
My New Favorite Pagination Method
Pagination is so important when it comes to displaying data in your app. This approach of server-side pagination in Next.js 13 Server Components is so cool for that. I implemented something similar on accident while building a dashboard and figured this works so well with pagination too.
Test this for yourself!: https://gist.github.com/joschan21/7adf028d81a75536abcb1e98100ac661
-- my links
Discord: https://discord.gg/4vCRMyzgA5
My GitHub: https://github.com/joschan21
published: 27 Jul 2023
Power Apps Gallery Pagination
#PowerApps #PaginatedGallery
This video is a step-by-step tutorial on Power Apps Gallery Pagination. This technique for Pagination in Power Apps utilizes the LastN & FirstN functions along with supported delegation logic which allows the Gallery to work with large data sources in which Power Apps will automatically break down your data source query in an optimized and performant manner. We will also provide dynamic filters for paging Size and Gallery filtering. The gallery will load data in batches of 100 thereby optimizing query performance as the user paginates through the gallery pagination control.
Check out my blog post which contains all the formulas showcased in this video on Gallery Pagination : https://rezadorrani.com/?p=474
Video covers the following:
✅ Pagination in Power A...
Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: https://bit.ly/bbg-social
Animation tools: Adobe Illustrator and After Eff...
Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: https://bit.ly/bbg-social
Animation tools: Adobe Illustrator and After Effects.
Checkout our bestselling System Design Interview books:
Volume 1: https://amzn.to/3Ou7gkd
Volume 2: https://amzn.to/3HqGozy
The digital version of System Design Interview books: https://bit.ly/3mlDSk9
ABOUT US:
Covering topics and trends in large-scale system design, from the authors of the best-selling System Design Interview series.
Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: https://bit.ly/bbg-social
Animation tools: Adobe Illustrator and After Effects.
Checkout our bestselling System Design Interview books:
Volume 1: https://amzn.to/3Ou7gkd
Volume 2: https://amzn.to/3HqGozy
The digital version of System Design Interview books: https://bit.ly/3mlDSk9
ABOUT US:
Covering topics and trends in large-scale system design, from the authors of the best-selling System Design Interview series.
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
Blog post on pagination: https://planetscale.com/blog/mysql-pagination.
V...
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
Blog post on pagination: https://planetscale.com/blog/mysql-pagination.
Video on deferred joins: https://planetscale.com/learn/courses/mysql-for-developers/examples/deferred-joins.
Article on deferred joins: https://aaronfrancis.com/2022/efficient-pagination-using-deferred-joins.
——————————————————
00:00 Intro
00:12 How to pronounce paginate
00:30 The two pagination methods
00:54 We have bosses
01:25 Select * from people
01:45 Deterministic ordering
03:20 Limit/offset pagination
05:17 Shifting records in offset pagination
06:12 Cursor based pagination
08:13 Ordering by two columns
09:23 Cursor pagination drawbacks
09:53 Cursor pagination advantages
10:50 Summary of differences
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
Blog post on pagination: https://planetscale.com/blog/mysql-pagination.
Video on deferred joins: https://planetscale.com/learn/courses/mysql-for-developers/examples/deferred-joins.
Article on deferred joins: https://aaronfrancis.com/2022/efficient-pagination-using-deferred-joins.
——————————————————
00:00 Intro
00:12 How to pronounce paginate
00:30 The two pagination methods
00:54 We have bosses
01:25 Select * from people
01:45 Deterministic ordering
03:20 Limit/offset pagination
05:17 Shifting records in offset pagination
06:12 Cursor based pagination
08:13 Ordering by two columns
09:23 Cursor pagination drawbacks
09:53 Cursor pagination advantages
10:50 Summary of differences
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/
#apidevelopment #pagination #softwaredevelopment
In API design, pagination is a technique used to manage and limit the amount of data returned by an API endpoi...
#apidevelopment #pagination #softwaredevelopment
In API design, pagination is a technique used to manage and limit the amount of data returned by an API endpoint. When dealing with large sets of data, it's not efficient or practical to return the entire dataset in a single response. Pagination allows the API to provide a subset or "page" of the data, making it more manageable for clients to retrieve and process.
#software #engineering #datascience #datascientist #api
#apidevelopment #pagination #softwaredevelopment
In API design, pagination is a technique used to manage and limit the amount of data returned by an API endpoint. When dealing with large sets of data, it's not efficient or practical to return the entire dataset in a single response. Pagination allows the API to provide a subset or "page" of the data, making it more manageable for clients to retrieve and process.
#software #engineering #datascience #datascientist #api
In this video we will implement some custom pagination in React to get a certain number of fetched posts per page. We will be using the useState and useEffect h...
In this video we will implement some custom pagination in React to get a certain number of fetched posts per page. We will be using the useState and useEffect hooks as well.
Code:
https://github.com/bradtraversy/simple_react_pagination
Sponsor: Freelancer Bundle (Use "brad25" for 25% off)
https://studywebdevelopment.com/freelancing.html
💖 Become a Patron: Show support & get perks!
http://www.patreon.com/traversymedia
Website & Udemy Courses
http://www.traversymedia.com
Follow Traversy Media:
https://www.facebook.com/traversymedia
https://www.twitter.com/traversymedia
https://www.instagram.com/traversymedia
In this video we will implement some custom pagination in React to get a certain number of fetched posts per page. We will be using the useState and useEffect hooks as well.
Code:
https://github.com/bradtraversy/simple_react_pagination
Sponsor: Freelancer Bundle (Use "brad25" for 25% off)
https://studywebdevelopment.com/freelancing.html
💖 Become a Patron: Show support & get perks!
http://www.patreon.com/traversymedia
Website & Udemy Courses
http://www.traversymedia.com
Follow Traversy Media:
https://www.facebook.com/traversymedia
https://www.twitter.com/traversymedia
https://www.instagram.com/traversymedia
Improve your website's user experience by learning Pagination in JavaScript. This video takes you step-by-step through the process, using a dummy JSON API for p...
Improve your website's user experience by learning Pagination in JavaScript. This video takes you step-by-step through the process, using a dummy JSON API for products as an example. Learn to avoid loading too much data at once, and instead deliver a smoother, faster browsing experience. We'll explore a few different way to handle pagination: client-side, statically generated pages, and server side rendered pages.
Learn Astro 3.0 - https://astrocourse.dev/
*** Resources ***
Diagraming with Eraser - https://app.eraser.io
Dummy Data API - https://dummyjson.com/docs/products
**DISCORD**
Join the Learn Build Teach Discord Server 💬 - https://discord.gg/vM2bagU
**STAY IN TOUCH 👋**
Newsletter 🗞 - https://www.jamesqquick.com/newsletter
Follow me on Twitter 🐦 - https://www.twitter.com/jamesqquick
Check out the Podcast - https://compressed.fm/
Courses - https://jamesqquick.com/courses
**QUESTIONS ABOUT MY SETUP**
Check out my Uses page for my VS Code setup, what recording equipment I use, etc. https://www.jamesqquick.com/uses
00:00 Introduction
01:24 Pagination Explained with Diagrams
05:42 Client-side Pagination Demo
08:35 SSG Pagination with Astro
11:45 SSR Pagination with Route Parameters
12:25 Astro Course and Outro
Improve your website's user experience by learning Pagination in JavaScript. This video takes you step-by-step through the process, using a dummy JSON API for products as an example. Learn to avoid loading too much data at once, and instead deliver a smoother, faster browsing experience. We'll explore a few different way to handle pagination: client-side, statically generated pages, and server side rendered pages.
Learn Astro 3.0 - https://astrocourse.dev/
*** Resources ***
Diagraming with Eraser - https://app.eraser.io
Dummy Data API - https://dummyjson.com/docs/products
**DISCORD**
Join the Learn Build Teach Discord Server 💬 - https://discord.gg/vM2bagU
**STAY IN TOUCH 👋**
Newsletter 🗞 - https://www.jamesqquick.com/newsletter
Follow me on Twitter 🐦 - https://www.twitter.com/jamesqquick
Check out the Podcast - https://compressed.fm/
Courses - https://jamesqquick.com/courses
**QUESTIONS ABOUT MY SETUP**
Check out my Uses page for my VS Code setup, what recording equipment I use, etc. https://www.jamesqquick.com/uses
00:00 Introduction
01:24 Pagination Explained with Diagrams
05:42 Client-side Pagination Demo
08:35 SSG Pagination with Astro
11:45 SSR Pagination with Route Parameters
12:25 Astro Course and Outro
We are very glad to start the REST APIs made easy course with the very first video on fundamentals of REST APIs, HTTP Methods, taxonomy around REST APIs etc. We...
We are very glad to start the REST APIs made easy course with the very first video on fundamentals of REST APIs, HTTP Methods, taxonomy around REST APIs etc. We hope that you get some value out of this course and these concepts help you thrive in your jobs, interviews and help you become better software engineers every day. Here are few links that you might want to refer before or during the course:
We hope that you get some value out of this course and these concepts help you thrive in your jobs, interviews and help you become better software engineers every day.
More on the topic:
✒https://developer.mozilla.org/en-US/docs/Glossary/REST
✒https://github.com/microsoft/api-guidelines
Previous videos to catch up on:
✒What is an API - https://youtu.be/dpcILJ8BTzU
✒REST Standards - https://youtu.be/nUuAWn0AAiY
✒What is REST API - https://youtu.be/ST8XxjOTIsg
------------------------------------------------------------------
Recommendations
------------------------------------------------------------------
Our full courses on youtube:
✒ System Design Primer Course: https://youtube.com/playlist?list=PLTCrU9sGyburBw9wNOHebv9SjlE4Elv5a
✒ REST APIs made easy:https://youtube.com/playlist?list=PLTCrU9sGybupzS5-3iYTsYUI1emBDKdHu
Some paid courses that we recommend:
✒Educative.io: https://bit.ly/3qnW5ku
✒Interviewready.io: https://get.interviewready.io/ (Use coupon code SUDOCODE for extra discount)
------------------------------------------------------------------
About Us
------------------------------------------------------------------
Created and Instructed by:
Yogita Sharma
✒ LinkedIn - https://www.linkedin.com/in/yogita-sharma-83400b55/
✒ Instagram - https://www.instagram.com/sudo.code1
✒ Facebook - https://www.facebook.com/sudo.code
✒ Medium - https://medium.com/@yogita088
Post-production(editing, thumbnail etc) managed by:
CiKi
✒ Website: www.ciki.co.in
✒ LinkedIn: https://www.linkedin.com/company/74735937
Colors and design by:
Naini Todi
✒ LinkedIn - https://www.linkedin.com/in/nainitodi/
Both Arpit and Yogita are software engineers and want to help other software engineers become better by providing high quality and well researched content by adding their creativity and teaching twist.
------------------------------------------------------------------
Join Us
------------------------------------------------------------------
Hangout with sudoCode:
✒Discord Server: https://discord.gg/rwD2PkeAxw
For business:
✒Email: sudocode.yogita@gmail.com
We are very glad to start the REST APIs made easy course with the very first video on fundamentals of REST APIs, HTTP Methods, taxonomy around REST APIs etc. We hope that you get some value out of this course and these concepts help you thrive in your jobs, interviews and help you become better software engineers every day. Here are few links that you might want to refer before or during the course:
We hope that you get some value out of this course and these concepts help you thrive in your jobs, interviews and help you become better software engineers every day.
More on the topic:
✒https://developer.mozilla.org/en-US/docs/Glossary/REST
✒https://github.com/microsoft/api-guidelines
Previous videos to catch up on:
✒What is an API - https://youtu.be/dpcILJ8BTzU
✒REST Standards - https://youtu.be/nUuAWn0AAiY
✒What is REST API - https://youtu.be/ST8XxjOTIsg
------------------------------------------------------------------
Recommendations
------------------------------------------------------------------
Our full courses on youtube:
✒ System Design Primer Course: https://youtube.com/playlist?list=PLTCrU9sGyburBw9wNOHebv9SjlE4Elv5a
✒ REST APIs made easy:https://youtube.com/playlist?list=PLTCrU9sGybupzS5-3iYTsYUI1emBDKdHu
Some paid courses that we recommend:
✒Educative.io: https://bit.ly/3qnW5ku
✒Interviewready.io: https://get.interviewready.io/ (Use coupon code SUDOCODE for extra discount)
------------------------------------------------------------------
About Us
------------------------------------------------------------------
Created and Instructed by:
Yogita Sharma
✒ LinkedIn - https://www.linkedin.com/in/yogita-sharma-83400b55/
✒ Instagram - https://www.instagram.com/sudo.code1
✒ Facebook - https://www.facebook.com/sudo.code
✒ Medium - https://medium.com/@yogita088
Post-production(editing, thumbnail etc) managed by:
CiKi
✒ Website: www.ciki.co.in
✒ LinkedIn: https://www.linkedin.com/company/74735937
Colors and design by:
Naini Todi
✒ LinkedIn - https://www.linkedin.com/in/nainitodi/
Both Arpit and Yogita are software engineers and want to help other software engineers become better by providing high quality and well researched content by adding their creativity and teaching twist.
------------------------------------------------------------------
Join Us
------------------------------------------------------------------
Hangout with sudoCode:
✒Discord Server: https://discord.gg/rwD2PkeAxw
For business:
✒Email: sudocode.yogita@gmail.com
Web API pagination is crucial for building scalable APIs. There are 2 different pagination standards that you can use. It's offset-based pagination and cursor-b...
Web API pagination is crucial for building scalable APIs. There are 2 different pagination standards that you can use. It's offset-based pagination and cursor-based pagination, sometimes referred to as continuation token based pagination. It's important that you understand how these standards work and pick the right one because it's not a one size fits all thing. In this video, I give you all the details you need to pick the right one for your use case.
#WebAPIDesign #Pagination
Timecodes
0:00 - API pagination intro
3:10 - Offset-based pagination
6:50 - Cursor-based pagination
9:57 - Comparison
Web API pagination is crucial for building scalable APIs. There are 2 different pagination standards that you can use. It's offset-based pagination and cursor-based pagination, sometimes referred to as continuation token based pagination. It's important that you understand how these standards work and pick the right one because it's not a one size fits all thing. In this video, I give you all the details you need to pick the right one for your use case.
#WebAPIDesign #Pagination
Timecodes
0:00 - API pagination intro
3:10 - Offset-based pagination
6:50 - Cursor-based pagination
9:57 - Comparison
Pagination is so important when it comes to displaying data in your app. This approach of server-side pagination in Next.js 13 Server Components is so cool for ...
Pagination is so important when it comes to displaying data in your app. This approach of server-side pagination in Next.js 13 Server Components is so cool for that. I implemented something similar on accident while building a dashboard and figured this works so well with pagination too.
Test this for yourself!: https://gist.github.com/joschan21/7adf028d81a75536abcb1e98100ac661
-- my links
Discord: https://discord.gg/4vCRMyzgA5
My GitHub: https://github.com/joschan21
Pagination is so important when it comes to displaying data in your app. This approach of server-side pagination in Next.js 13 Server Components is so cool for that. I implemented something similar on accident while building a dashboard and figured this works so well with pagination too.
Test this for yourself!: https://gist.github.com/joschan21/7adf028d81a75536abcb1e98100ac661
-- my links
Discord: https://discord.gg/4vCRMyzgA5
My GitHub: https://github.com/joschan21
#PowerApps #PaginatedGallery
This video is a step-by-step tutorial on Power Apps Gallery Pagination. This technique for Pagination in Power Apps utilizes the La...
#PowerApps #PaginatedGallery
This video is a step-by-step tutorial on Power Apps Gallery Pagination. This technique for Pagination in Power Apps utilizes the LastN & FirstN functions along with supported delegation logic which allows the Gallery to work with large data sources in which Power Apps will automatically break down your data source query in an optimized and performant manner. We will also provide dynamic filters for paging Size and Gallery filtering. The gallery will load data in batches of 100 thereby optimizing query performance as the user paginates through the gallery pagination control.
Check out my blog post which contains all the formulas showcased in this video on Gallery Pagination : https://rezadorrani.com/?p=474
Video covers the following:
✅ Pagination in Power Apps Galleries
✅ Delegable queries for Paginating Gallery
✅ Optimized load of data via Pagination in a Gallery
✅ Dynamic page size and filters for Gallery
Delegation Playlist - https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD
Table of Contents:
00:00 - Intro
00:43 - Gallery with Pagination Demo
02:57 - Optimized data loading in Power Apps Gallery control (Delegation)
05:50 - Delegation issue with FirstN and LastN functions
08:22 - Setting Gallery control for Pagination without a delegation warning
10:37 - Adding the Pagination controls
19:44 - Subscribe
#PowerApps #PaginatedGallery
This video is a step-by-step tutorial on Power Apps Gallery Pagination. This technique for Pagination in Power Apps utilizes the LastN & FirstN functions along with supported delegation logic which allows the Gallery to work with large data sources in which Power Apps will automatically break down your data source query in an optimized and performant manner. We will also provide dynamic filters for paging Size and Gallery filtering. The gallery will load data in batches of 100 thereby optimizing query performance as the user paginates through the gallery pagination control.
Check out my blog post which contains all the formulas showcased in this video on Gallery Pagination : https://rezadorrani.com/?p=474
Video covers the following:
✅ Pagination in Power Apps Galleries
✅ Delegable queries for Paginating Gallery
✅ Optimized load of data via Pagination in a Gallery
✅ Dynamic page size and filters for Gallery
Delegation Playlist - https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD
Table of Contents:
00:00 - Intro
00:43 - Gallery with Pagination Demo
02:57 - Optimized data loading in Power Apps Gallery control (Delegation)
05:50 - Delegation issue with FirstN and LastN functions
08:22 - Setting Gallery control for Pagination without a delegation warning
10:37 - Adding the Pagination controls
19:44 - Subscribe
Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: https://bit.ly/bbg-social
Animation tools: Adobe Illustrator and After Effects.
Checkout our bestselling System Design Interview books:
Volume 1: https://amzn.to/3Ou7gkd
Volume 2: https://amzn.to/3HqGozy
The digital version of System Design Interview books: https://bit.ly/3mlDSk9
ABOUT US:
Covering topics and trends in large-scale system design, from the authors of the best-selling System Design Interview series.
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
Blog post on pagination: https://planetscale.com/blog/mysql-pagination.
Video on deferred joins: https://planetscale.com/learn/courses/mysql-for-developers/examples/deferred-joins.
Article on deferred joins: https://aaronfrancis.com/2022/efficient-pagination-using-deferred-joins.
——————————————————
00:00 Intro
00:12 How to pronounce paginate
00:30 The two pagination methods
00:54 We have bosses
01:25 Select * from people
01:45 Deterministic ordering
03:20 Limit/offset pagination
05:17 Shifting records in offset pagination
06:12 Cursor based pagination
08:13 Ordering by two columns
09:23 Cursor pagination drawbacks
09:53 Cursor pagination advantages
10:50 Summary of differences
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/
#apidevelopment #pagination #softwaredevelopment
In API design, pagination is a technique used to manage and limit the amount of data returned by an API endpoint. When dealing with large sets of data, it's not efficient or practical to return the entire dataset in a single response. Pagination allows the API to provide a subset or "page" of the data, making it more manageable for clients to retrieve and process.
#software #engineering #datascience #datascientist #api
In this video we will implement some custom pagination in React to get a certain number of fetched posts per page. We will be using the useState and useEffect hooks as well.
Code:
https://github.com/bradtraversy/simple_react_pagination
Sponsor: Freelancer Bundle (Use "brad25" for 25% off)
https://studywebdevelopment.com/freelancing.html
💖 Become a Patron: Show support & get perks!
http://www.patreon.com/traversymedia
Website & Udemy Courses
http://www.traversymedia.com
Follow Traversy Media:
https://www.facebook.com/traversymedia
https://www.twitter.com/traversymedia
https://www.instagram.com/traversymedia
Improve your website's user experience by learning Pagination in JavaScript. This video takes you step-by-step through the process, using a dummy JSON API for products as an example. Learn to avoid loading too much data at once, and instead deliver a smoother, faster browsing experience. We'll explore a few different way to handle pagination: client-side, statically generated pages, and server side rendered pages.
Learn Astro 3.0 - https://astrocourse.dev/
*** Resources ***
Diagraming with Eraser - https://app.eraser.io
Dummy Data API - https://dummyjson.com/docs/products
**DISCORD**
Join the Learn Build Teach Discord Server 💬 - https://discord.gg/vM2bagU
**STAY IN TOUCH 👋**
Newsletter 🗞 - https://www.jamesqquick.com/newsletter
Follow me on Twitter 🐦 - https://www.twitter.com/jamesqquick
Check out the Podcast - https://compressed.fm/
Courses - https://jamesqquick.com/courses
**QUESTIONS ABOUT MY SETUP**
Check out my Uses page for my VS Code setup, what recording equipment I use, etc. https://www.jamesqquick.com/uses
00:00 Introduction
01:24 Pagination Explained with Diagrams
05:42 Client-side Pagination Demo
08:35 SSG Pagination with Astro
11:45 SSR Pagination with Route Parameters
12:25 Astro Course and Outro
We are very glad to start the REST APIs made easy course with the very first video on fundamentals of REST APIs, HTTP Methods, taxonomy around REST APIs etc. We hope that you get some value out of this course and these concepts help you thrive in your jobs, interviews and help you become better software engineers every day. Here are few links that you might want to refer before or during the course:
We hope that you get some value out of this course and these concepts help you thrive in your jobs, interviews and help you become better software engineers every day.
More on the topic:
✒https://developer.mozilla.org/en-US/docs/Glossary/REST
✒https://github.com/microsoft/api-guidelines
Previous videos to catch up on:
✒What is an API - https://youtu.be/dpcILJ8BTzU
✒REST Standards - https://youtu.be/nUuAWn0AAiY
✒What is REST API - https://youtu.be/ST8XxjOTIsg
------------------------------------------------------------------
Recommendations
------------------------------------------------------------------
Our full courses on youtube:
✒ System Design Primer Course: https://youtube.com/playlist?list=PLTCrU9sGyburBw9wNOHebv9SjlE4Elv5a
✒ REST APIs made easy:https://youtube.com/playlist?list=PLTCrU9sGybupzS5-3iYTsYUI1emBDKdHu
Some paid courses that we recommend:
✒Educative.io: https://bit.ly/3qnW5ku
✒Interviewready.io: https://get.interviewready.io/ (Use coupon code SUDOCODE for extra discount)
------------------------------------------------------------------
About Us
------------------------------------------------------------------
Created and Instructed by:
Yogita Sharma
✒ LinkedIn - https://www.linkedin.com/in/yogita-sharma-83400b55/
✒ Instagram - https://www.instagram.com/sudo.code1
✒ Facebook - https://www.facebook.com/sudo.code
✒ Medium - https://medium.com/@yogita088
Post-production(editing, thumbnail etc) managed by:
CiKi
✒ Website: www.ciki.co.in
✒ LinkedIn: https://www.linkedin.com/company/74735937
Colors and design by:
Naini Todi
✒ LinkedIn - https://www.linkedin.com/in/nainitodi/
Both Arpit and Yogita are software engineers and want to help other software engineers become better by providing high quality and well researched content by adding their creativity and teaching twist.
------------------------------------------------------------------
Join Us
------------------------------------------------------------------
Hangout with sudoCode:
✒Discord Server: https://discord.gg/rwD2PkeAxw
For business:
✒Email: sudocode.yogita@gmail.com
Web API pagination is crucial for building scalable APIs. There are 2 different pagination standards that you can use. It's offset-based pagination and cursor-based pagination, sometimes referred to as continuation token based pagination. It's important that you understand how these standards work and pick the right one because it's not a one size fits all thing. In this video, I give you all the details you need to pick the right one for your use case.
#WebAPIDesign #Pagination
Timecodes
0:00 - API pagination intro
3:10 - Offset-based pagination
6:50 - Cursor-based pagination
9:57 - Comparison
Pagination is so important when it comes to displaying data in your app. This approach of server-side pagination in Next.js 13 Server Components is so cool for that. I implemented something similar on accident while building a dashboard and figured this works so well with pagination too.
Test this for yourself!: https://gist.github.com/joschan21/7adf028d81a75536abcb1e98100ac661
-- my links
Discord: https://discord.gg/4vCRMyzgA5
My GitHub: https://github.com/joschan21
#PowerApps #PaginatedGallery
This video is a step-by-step tutorial on Power Apps Gallery Pagination. This technique for Pagination in Power Apps utilizes the LastN & FirstN functions along with supported delegation logic which allows the Gallery to work with large data sources in which Power Apps will automatically break down your data source query in an optimized and performant manner. We will also provide dynamic filters for paging Size and Gallery filtering. The gallery will load data in batches of 100 thereby optimizing query performance as the user paginates through the gallery pagination control.
Check out my blog post which contains all the formulas showcased in this video on Gallery Pagination : https://rezadorrani.com/?p=474
Video covers the following:
✅ Pagination in Power Apps Galleries
✅ Delegable queries for Paginating Gallery
✅ Optimized load of data via Pagination in a Gallery
✅ Dynamic page size and filters for Gallery
Delegation Playlist - https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD
Table of Contents:
00:00 - Intro
00:43 - Gallery with Pagination Demo
02:57 - Optimized data loading in Power Apps Gallery control (Delegation)
05:50 - Delegation issue with FirstN and LastN functions
08:22 - Setting Gallery control for Pagination without a delegation warning
10:37 - Adding the Pagination controls
19:44 - Subscribe
Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: https://bit.ly/bbg-social
Animation tools: Adobe Illustrator and After Effects.
Checkout our bestselling System Design Interview books:
Volume 1: https://amzn.to/3Ou7gkd
Volume 2: https://amzn.to/3HqGozy
The digital version of System Design Interview books: https://bit.ly/3mlDSk9
ABOUT US:
Covering topics and trends in large-scale system design, from the authors of the best-selling System Design Interview series.
Get a Free System Design PDF with 158 pages by subscribing to our weekly newsletter: https://bit.ly/bbg-social
Animation tools: Adobe Illustrator and After Effects.
Checkout our bestselling System Design Interview books:
Volume 1: https://amzn.to/3Ou7gkd
Volume 2: https://amzn.to/3HqGozy
The digital version of System Design Interview books: https://bit.ly/3mlDSk9
ABOUT US:
Covering topics and trends in large-scale system design, from the authors of the best-selling System Design Interview series.
📚 Learn more about PlanetScale at https://planetscale.com/youtube.
——————————————————
Blog post on pagination: https://planetscale.com/blog/mysql-pagination.
Video on deferred joins: https://planetscale.com/learn/courses/mysql-for-developers/examples/deferred-joins.
Article on deferred joins: https://aaronfrancis.com/2022/efficient-pagination-using-deferred-joins.
——————————————————
00:00 Intro
00:12 How to pronounce paginate
00:30 The two pagination methods
00:54 We have bosses
01:25 Select * from people
01:45 Deterministic ordering
03:20 Limit/offset pagination
05:17 Shifting records in offset pagination
06:12 Cursor based pagination
08:13 Ordering by two columns
09:23 Cursor pagination drawbacks
09:53 Cursor pagination advantages
10:50 Summary of differences
——————————————————
💬 Follow PlanetScale on social media
• Twitter: https://twitter.com/planetscaledata
• Discord: https://discord.gg/pDUGAAFEJx
• TikTok: https://www.tiktok.com/@planetscale
• Twitch: https://www.twitch.tv/planetscale
• LinkedIn: https://www.linkedin.com/company/planetscale/
#apidevelopment #pagination #softwaredevelopment
In API design, pagination is a technique used to manage and limit the amount of data returned by an API endpoint. When dealing with large sets of data, it's not efficient or practical to return the entire dataset in a single response. Pagination allows the API to provide a subset or "page" of the data, making it more manageable for clients to retrieve and process.
#software #engineering #datascience #datascientist #api
In this video we will implement some custom pagination in React to get a certain number of fetched posts per page. We will be using the useState and useEffect hooks as well.
Code:
https://github.com/bradtraversy/simple_react_pagination
Sponsor: Freelancer Bundle (Use "brad25" for 25% off)
https://studywebdevelopment.com/freelancing.html
💖 Become a Patron: Show support & get perks!
http://www.patreon.com/traversymedia
Website & Udemy Courses
http://www.traversymedia.com
Follow Traversy Media:
https://www.facebook.com/traversymedia
https://www.twitter.com/traversymedia
https://www.instagram.com/traversymedia
Improve your website's user experience by learning Pagination in JavaScript. This video takes you step-by-step through the process, using a dummy JSON API for products as an example. Learn to avoid loading too much data at once, and instead deliver a smoother, faster browsing experience. We'll explore a few different way to handle pagination: client-side, statically generated pages, and server side rendered pages.
Learn Astro 3.0 - https://astrocourse.dev/
*** Resources ***
Diagraming with Eraser - https://app.eraser.io
Dummy Data API - https://dummyjson.com/docs/products
**DISCORD**
Join the Learn Build Teach Discord Server 💬 - https://discord.gg/vM2bagU
**STAY IN TOUCH 👋**
Newsletter 🗞 - https://www.jamesqquick.com/newsletter
Follow me on Twitter 🐦 - https://www.twitter.com/jamesqquick
Check out the Podcast - https://compressed.fm/
Courses - https://jamesqquick.com/courses
**QUESTIONS ABOUT MY SETUP**
Check out my Uses page for my VS Code setup, what recording equipment I use, etc. https://www.jamesqquick.com/uses
00:00 Introduction
01:24 Pagination Explained with Diagrams
05:42 Client-side Pagination Demo
08:35 SSG Pagination with Astro
11:45 SSR Pagination with Route Parameters
12:25 Astro Course and Outro
We are very glad to start the REST APIs made easy course with the very first video on fundamentals of REST APIs, HTTP Methods, taxonomy around REST APIs etc. We hope that you get some value out of this course and these concepts help you thrive in your jobs, interviews and help you become better software engineers every day. Here are few links that you might want to refer before or during the course:
We hope that you get some value out of this course and these concepts help you thrive in your jobs, interviews and help you become better software engineers every day.
More on the topic:
✒https://developer.mozilla.org/en-US/docs/Glossary/REST
✒https://github.com/microsoft/api-guidelines
Previous videos to catch up on:
✒What is an API - https://youtu.be/dpcILJ8BTzU
✒REST Standards - https://youtu.be/nUuAWn0AAiY
✒What is REST API - https://youtu.be/ST8XxjOTIsg
------------------------------------------------------------------
Recommendations
------------------------------------------------------------------
Our full courses on youtube:
✒ System Design Primer Course: https://youtube.com/playlist?list=PLTCrU9sGyburBw9wNOHebv9SjlE4Elv5a
✒ REST APIs made easy:https://youtube.com/playlist?list=PLTCrU9sGybupzS5-3iYTsYUI1emBDKdHu
Some paid courses that we recommend:
✒Educative.io: https://bit.ly/3qnW5ku
✒Interviewready.io: https://get.interviewready.io/ (Use coupon code SUDOCODE for extra discount)
------------------------------------------------------------------
About Us
------------------------------------------------------------------
Created and Instructed by:
Yogita Sharma
✒ LinkedIn - https://www.linkedin.com/in/yogita-sharma-83400b55/
✒ Instagram - https://www.instagram.com/sudo.code1
✒ Facebook - https://www.facebook.com/sudo.code
✒ Medium - https://medium.com/@yogita088
Post-production(editing, thumbnail etc) managed by:
CiKi
✒ Website: www.ciki.co.in
✒ LinkedIn: https://www.linkedin.com/company/74735937
Colors and design by:
Naini Todi
✒ LinkedIn - https://www.linkedin.com/in/nainitodi/
Both Arpit and Yogita are software engineers and want to help other software engineers become better by providing high quality and well researched content by adding their creativity and teaching twist.
------------------------------------------------------------------
Join Us
------------------------------------------------------------------
Hangout with sudoCode:
✒Discord Server: https://discord.gg/rwD2PkeAxw
For business:
✒Email: sudocode.yogita@gmail.com
Web API pagination is crucial for building scalable APIs. There are 2 different pagination standards that you can use. It's offset-based pagination and cursor-based pagination, sometimes referred to as continuation token based pagination. It's important that you understand how these standards work and pick the right one because it's not a one size fits all thing. In this video, I give you all the details you need to pick the right one for your use case.
#WebAPIDesign #Pagination
Timecodes
0:00 - API pagination intro
3:10 - Offset-based pagination
6:50 - Cursor-based pagination
9:57 - Comparison
Pagination is so important when it comes to displaying data in your app. This approach of server-side pagination in Next.js 13 Server Components is so cool for that. I implemented something similar on accident while building a dashboard and figured this works so well with pagination too.
Test this for yourself!: https://gist.github.com/joschan21/7adf028d81a75536abcb1e98100ac661
-- my links
Discord: https://discord.gg/4vCRMyzgA5
My GitHub: https://github.com/joschan21
#PowerApps #PaginatedGallery
This video is a step-by-step tutorial on Power Apps Gallery Pagination. This technique for Pagination in Power Apps utilizes the LastN & FirstN functions along with supported delegation logic which allows the Gallery to work with large data sources in which Power Apps will automatically break down your data source query in an optimized and performant manner. We will also provide dynamic filters for paging Size and Gallery filtering. The gallery will load data in batches of 100 thereby optimizing query performance as the user paginates through the gallery pagination control.
Check out my blog post which contains all the formulas showcased in this video on Gallery Pagination : https://rezadorrani.com/?p=474
Video covers the following:
✅ Pagination in Power Apps Galleries
✅ Delegable queries for Paginating Gallery
✅ Optimized load of data via Pagination in a Gallery
✅ Dynamic page size and filters for Gallery
Delegation Playlist - https://www.youtube.com/playlist?list=PLTyFh-qDKAiE6ia-D94Qk5-AzpN4dqOmD
Table of Contents:
00:00 - Intro
00:43 - Gallery with Pagination Demo
02:57 - Optimized data loading in Power Apps Gallery control (Delegation)
05:50 - Delegation issue with FirstN and LastN functions
08:22 - Setting Gallery control for Pagination without a delegation warning
10:37 - Adding the Pagination controls
19:44 - Subscribe
Pagination is the process of dividing a document into discrete pages, either electronic pages or printed pages. Today printed pages are usually produced by outputting an electronic file to a printing device, such as a desktop printer or a modern printing press. These electronic files may for example be Microsoft Word, PDF or QXD files. They will usually already incorporate the instructions for pagination, among other formatting instructions. Pagination encompasses rules and algorithms for deciding where page breaks will fall, which depend partly on cultural considerations about which content belongs on the same page: for example one may try to avoid widows and orphans. Some systems are more sophisticated than others in this respect. Before the rise of information technology (IT), pagination was a manual process: all pagination was decided by a human. Today, most pagination is performed by machines, although humans often override particular decisions (e.g. by inserting a hard page break).