How a query optimization gave birth to infinite scroll

The Backend Engineering Show with Hussein Nasser by Hussein Nasser

Jul 10, 202600:21:20Technology

The infinite scroll in social media as we know it today is despised by all. But it always start as a bad idea. It originated as a result of UI change to relief the backend database from inefficient queries. I explore thi...

Related Episodes

Continue listening to more episodes from The Backend Engineering Show with Hussein Nasser.

How open ai agents "hacked" hugging face

Aug 23, 2026 - 00:17:57

How open ai agents "hacked" hugging face

Postgres is half as fast in Linux 7.0

Jun 17, 2026 - 00:34:08

An aws engineer discovered a 50% regression in postgres throughput while testing the new Linux 7.0 kernel...

Don't let AI rob you

Jun 8, 2026 - 00:31:53

A discussion about why many engineers still love the struggle, the mistakes, and the process of figuring...

My new book - Root cause, Stories from two decades of backend bugs

Apr 15, 2026 - 00:09:48

I wrote a new book that has been in the works for years. It is called Root Cause , and it is for those wh...

5 Backend Design Patterns for Managing Threads and Sockets

Jan 19, 2026 - 00:46:09

In this video I introduce 5 different design patterns for building backend applications. Each mode explai...

Page Tables

Dec 15, 2025 - 00:46:39

Page tables provide the mapping between virtual memory and physical memory for each process. This means i...

CPU and Kernel Page Faults

Nov 24, 2025 - 00:48:37

Page faults occurs when the process tries to access a memory that isn’t backed by a physical page kernel...

Amazon US-EAST-1 Outage in Details

Oct 31, 2025 - 00:24:26

On October 19 2025 AWS experienced an outage that lasted over a day, 10 days later we finally got the roo...