Pagination in MySQL - offset vs. cursor

Показать описание

——————————————————
——————————————————
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

PlanetScale

Рекомендации по теме

Комментарии

I use both techniques, but most of the time I use limit/offset because the need for paginating to a specific page, I use cursor technique for paginating notifications and tasks and similar things.
Thanks Aaron! that was an amazing video as usual.

ahmad-murery

Your content is fenomenal. Explanation and visualization is great. One of the best DB channels out there 👏

username

Cursor pagination seems super useful in scenarios, where you have:
a) infinite scroll pagination
b) a table that updates in real time
c) both

itsxFUL

I’m always actually learning stuff I thought I already knew with you guys. Great content!

Really clear and not sloppy, I like the way you demonstrate thing to people and it's really helpful! Thanks for such great content!

yangsui

Im about to add pagination to an old report, and at first I was going with limit offset, but after watching this video I know it makes a lot more sense to just use cursor. Thanks for such an organized and well thought out video.🎉🎉

rafl

Ive been looking at articles for cursor based pagination, this has been the most informative in actually implementing it. Thank you

ben-brady

Paginate vs Paginate is the next great battle in tech. Great deep dive on the differences between the two paginate (paginate?) methods that give a really good framework to help decide when you might reach for each one.

A++++ would buy again.

chrispian

that was really informative. keep up the great content. i feel like db subjects are not really talked about. so this channel is a blessing

andredasilva

This video is insanely timely, great explanation, thanks!!

TamDNB

this is an excellent description of the differences between the two methods, thank you for putting this together!

ninedulkar

I've been using paginate, chunk and cursor in Laravel, but only LIMIT OFFSET in MySQL. This is a great video! Thanks!

NathanBudd

I learnt a new thing today! Thank you for the excellent teaching!

ucretsiztakipci

You are the first person to explain this in a way I understand, while still being very technical and using SQL examples.

vamosOrea

Super helpful explanation and visuals! Thank you!

joey

I have been working with MySQL for last 17 years and I never use cursor but your video helped me to understand MySQL cursor. Thank you.

LiveNobin

You're raising the bar with each and every video, Aaron. This is not fair!

FarazSamapoor

very cool content and friendly explain, thank you

khanhpd

It's such a great show.

I enjoy it more than then education content.
Good job PlanetScale.

riolly

This was very nice an d compact lesson, thanks mate

sampleshawn

Pagination in MySQL - offset vs. cursor

Pagination in MySQL - offset vs. cursor

The Hidden Dangers of SQL OFFSET: Pagination Woes Explained

SQL for pagination queries - memory and performance

You’re Probably Doing Pagination Wrong

SQL for pagination queries - advanced options

don’t use “offset” in your SQL

Episode-015 - Using MySQL Document Store: limit() & offset ()

Pagination in SQL | Offset fetch next in SQL Server | search filter with dynamic pagination in SQL

MySQL LIMIT and OFFSET: Mastering Pagination in MySQL

Episode-038 - Paginating Data in MySQL using limit and offset

MYSQL LIMIT AND OFFSET QUERY | MYSQL LIMIT OFFSET PAGINATION

Extremely FAST Paging With Cursor Pagination And Database Index Seek

Mysql pagination without offset

My New Favorite Pagination Method

MySQL : How to manage mysql offset and limit in pagination

MySQL Limit and Offset Complete Tutorial | MySQL for Beginners

SQL Server - Pagination | Offset and Fetch Clause

SQL Pagination - Offset VS Seek

Pagination is sql server in 2008,2012,2014 | Offset Fetch-Next

Creating a simple pagination using php and mysql

MySQL : Does LIMIT OFFSET,LENGTH require ORDER BY for pagination?

Pagination with OFFSET FETCH - SQL Server

Web API Pagination | Offset-based vs Cursor-based

How to design API that display and filter through millions of products.REST API Filters & Pagina...