logo
episode-header-image
Yesterday
21m 20s

How a query optimization gave birth to i...

Hussein Nasser
About this episode

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

Up next
Jun 17
Postgres is half as fast in Linux 7.0
An aws engineer discovered a 50% regression in postgres throughput while testing the new Linux 7.0 kernel. The cause turns out to be massive TLB and page faults exacerbated by Postgres process-based design. In this backend engineering show episode I dive deep into how this was di ... Show More
34m 8s
Jun 8
Don't let AI rob you
A discussion about why many engineers still love the struggle, the mistakes, and the process of figuring things out themselves. This is how we grow and get better and stronger. Letting AI do everything (even though it can’t) robs us this feeling.. 
31m 53s
Apr 15
New Book: Root cause
I wrote a new book that has been in the works for years. It is called Root Cause, and it is for those who enjoy the art of backend engineering.Early in my career, 20 years ago, I built backend and database applications without fully grasping their inner mechanics. Performance iss ... Show More
9m 48s
Recommended Episodes
Dec 2024
Web Development with Next.js and Vercel
tail spinning
1h 6m
Mar 2024
747: Middleware Explained
Join Wes and Scott for a hasty episode of Syntax as they unpack the power of middleware for developers, covering caching, authentication, A/B testing, error handling, and user redirection in a quick, punchy rundown to supercharge your backend skills! Show Notes 00:00 Welcome t ... Show More
27m 44s
Nov 2022
The practicalities of releasing models
Recently Chris and Daniel briefly discussed the Open RAIL-M licensing and model releases on Hugging Face. In this episode, Daniel follows up on this topic based on some recent practical experience. Also included is a discussion about graph neural networks, message passing, and tw ... Show More
37m 19s
Jul 2024
798: Self Hosting: Reverse Proxy Servers
Scott and Wes serve up an episode on reverse proxy servers. They discuss popular options like CF Tunnels, Caddy, Nginx, Apache, and more, explaining why you might need one for load balancing, SSL certificates, security, and managing multiple servers. Show Notes 00:00 Welcome t ... Show More
17m 7s
Jan 2019
You might want to read up on PAW Patrol
Your 3 intrepid hosts try to explain JS concepts (bind/apply, thunks, and ReasonML) to each other as if we’re five year olds. Hilarity and/or confusion ensues. During Pro Tip Time, Suz tells a story of woe, KBall motivates himself, and Jerod tries to keep you in the flow. Finally ... Show More
1h 1m
Jun 2007
Tech Talk for June 11,2007
Tech talk 
9m 35s
Oct 2024
#479: Designing Effective Load Tests for Your Python App
See the full show notes for this episode on the website at <a href="https://talkpython.fm/479">talkpython.fm/479</a> 
59m 6s