{"podcast":{"title":"The Backend Engineering Show with Hussein Nasser","slug":"the-backend-engineering-show-with-hussein-nasser-847440","podcast_index_feed_id":847440,"rss_url":"https://anchor.fm/s/1eb6d14/podcast/rss","website_url":"https://database.husseinnasser.com","image_url":"https://d3t3ozftmdmh3i.cloudfront.net/production/podcast_uploaded_nologo/222061/222061-1626111277047-d82a050054721.jpg","author":"Hussein Nasser","episode_count":541,"summary":"Welcome to the Backend Engineering Show podcast with your host Hussein Nasser. If you like software engineering you’ve come to the right place. I discuss all sorts of software engineering technologies and news with specific focus on the backend. All opinions are my own. Most of my content in the podcast is an audio version of videos I post on my youtube channel here http://www.youtube.com/c/HusseinNasser-software-engineering Buy me a coffee https://www.buymeacoffee.com/hnasr 🧑‍🏫 Courses I Teach https://husseinnasser.com/courses","last_synced_at":"2026-07-11T00:20:07.790472+00:00","page_url":"https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440"},"episode":{"title":"How a query optimization gave birth to infinite scroll","slug":"how-a-query-optimization-gave-birth-to-infinite-scroll","published_at":"2026-07-10T13:50:00+00:00","page_url":"https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440/how-a-query-optimization-gave-birth-to-infinite-scroll","show_page_url":"https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440","url":"https://podcasters.spotify.com/pod/show/hnasr/episodes/How-a-query-optimization-gave-birth-to-infinite-scroll-e3lrc2n","audio_url":"https://anchor.fm/s/1eb6d14/podcast/play/122580503/https%3A%2F%2Fd3ctxlq1ktw2nl.cloudfront.net%2Fstaging%2F2026-6-8%2Fc5a227fe-ff9d-b173-da0c-d3892f83119d.m4a","summary":"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","meta_description":"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 r…","key_points":[],"chapters":[],"topics":[],"duration_seconds":1280,"processing_state":"not_requested","actions":[{"name":"request_transcript","method":"POST","url":"https://stenobird.com/v1/public/podcasts/the-backend-engineering-show-with-hussein-nasser-847440/episodes/how-a-query-optimization-gave-birth-to-infinite-scroll/transcription-requests","description":"Idempotently request low-priority transcript generation for this episode."},{"name":"read_markdown","method":"GET","url":"https://stenobird.com/podcast/the-backend-engineering-show-with-hussein-nasser-847440/how-a-query-optimization-gave-birth-to-infinite-scroll.md","description":"Read the agent-friendly Markdown representation of this episode resource."}]}}