How a query optimization gave birth to infinite scroll
The Backend Engineering Show with Hussein Nasser

How a query optimization gave birth to infinite scroll

B1IntermediateJuly 10, 202621 min

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 this in this episode of the backend engineering. 0:00 Intro1:00 Classic Paged results 6:23 Limitations of paging9:00 The scroll interface 12:00 How TikTok to infinite scroll 14:00 The current state

Play episode

Opens the player: the full transcript, every word clickable, with translation and flashcards.

Try it: tap any word

Real sentences from the start of this episode. Every word is marked with its level.

Sentence 1 of 12 · 0:00

.

And I'm using the word ideal because I don't have any other adjectives that are not depressing.

Tap a word to see its meaning in your language.

Do you know these words?

8 harder words from this episode. Tap one to see what it means, then mark it.

Mark a few words and we'll tell you how this episode fits your level.

Is this episode right for you?

B1

B1 · Intermediate

Fine if you can follow simple news

A1 18%A2 15%B1 8%B2 45%C1 13%
  • 41% of the words are B1 or easier.
  • 137 words a minute: a natural pace.
  • 64 harder words (B2 and up) in the whole episode.

Transcript

The opening of the episode. The whole transcript is in the player.

0:00

I think we can all agree that the current state of social media consumption is far from ideal. And I'm using the word ideal because I don't have any other adjectives that are not depressing. You see, no one, and I can, I think, safely say no one, goes into any of these social media, tiktok or instagram or youtube shorts and goes out of that session

0:36

if they ever get out because believe it or not the companies behind that will do everything they can through algorithms and and then studying of the human psychology to keep you scrolling right and if you ever ever get out of that session you're freed rarely that you either feel feel good about it or talk about it or there's nothing prideful about

1:14

it there's absolutely zero value even if you learn something or you learned an idea or something it feels i don't know hello but i don't want to make this video depressing because everybody knows the current state of social media i want to talk about that that idea of infinite scroll didn't always started as an infinite scroll it actually started as a solution to a

That was the opening. The rest of the episode (19 min) is in the player: every word clickable, with translation, saved words and flashcards.

Continue in the player

Automatically generated from the audio. May contain errors. Audio belongs to its publisher and is played from their feed. Rights holders can request removal — copyright & takedown policy