How a query optimization gave birth to Infinite scroll

The infinite scroll in social media as we know it today is despised by all. But it didn't always start as a bad idea. It originated as a result of UI change to relief the backend database from inefficient queries. I explore this in this episode of the backend engineering. 0:00 Intro 1:00 Classic Paged results 6:23 Limitations of paging 9:00 The scroll interface 12:00 How TikTok to infinite scroll 14:00 The current state Intermediate and Advanced Backend Engineering Course Bundle courses.husseinnasser.com/bundle My Book, Root Cause: Stories and Lessons from Two Decades of Backend Engineering Bugs amzn.to/4cKfZhe Backend, Database, OS Courses courses.husseinnasser.com Fundamentals of Database Engineering database.husseinnasser.com Fundamentals of Operating Systems Course oscourse.win NodeJS Internals and Architecture node.win Fundamentals of Backend Engineering backend.win Follow me on Substack hnasr.substack.com Members Only Content youtube.com/playlist?list=UUMO_ML5xP23TOWKUcc-oAE_Eg Become a Member on YouTube youtube.com/channel/UC_ML5xP23TOWKUcc-oAE_Eg/join Stay Awesome, Hussein