Jan 19

5 Backend Design Patterns for Managing Threads and Sockets

In this video I introduce 5 different design patterns for building backend applications. Each mode explains how a socket listener is established, a connections are established and how threads and connections are managed to read, write and process requests.

46m 9s

Dec 15

Page Tables

Page tables provide the mapping between virtual memory and physical memory for each process. This means it needs to be as efficient and as fast as possible. I explore the inner workings of page tables in this episode.0:00 Intro2:00 Virtual Memory ⁃ ⁃ 8:00 MMU10:00 Page Tables ⁃ ⁃ ... Show More

46m 39s

Nov 24

CPU and Kernel Page Faults

<p>Page faults occurs when the process tries to access a memory that isn’t backed by a physical page kernel raises a fault which loads a page. It happens on first access, stack expansion, COW, swap and much more. However it comes with a cost. </p><p><br /></p><p>In this episode o ... Show More

48m 37s

May 2024

Erik Darling and Kendra Little Rate SQL Server Perf Tuning Techniques

Erik Darling joins Kendra Little to rate different SQL Server Performance Tuning Techniques in episode 81 of the Dear SQL DBA podcast. We share our opinions of... (deep breath) Recompile hints, Query Store hints and plan forcing, CTEs, Resource Governor, the legacy cardinality ... Show More

1h 4m

Sep 2021

S17:E9 - What are some database architectures and their use cases (Kyle Bernhardy)

In this episode, we talk about database architectures and some of their use cases, with Kyle Bernhardy, CTO of HarperDB. Kyle talks about what a database is, different types of databases, and when you might want to use one type of database over another. Show Links DevDiscuss (spo ... Show More

48m 31s

Dec 2019

Building The Materialize Engine For Interactive Streaming Analytics In SQL

<div class="wp-block-jetpack-markdown"><h2>Summary</h2> <p>Transactional databases used in applications are optimized for fast reads and writes with relatively simple queries on a small number of records. Data warehouses are optimized for batched writes and complex analytical qu ... Show More

48m 7s

Oct 2023

166: Speedy Database Queries with Lukas Fittl

<p>- pganalyze: <a href="https://pganalyze.com/">https://pganalyze.com/</a></p><p>- Weekly series "5mins of Postgres": <a href="https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw">https://www.youtube.com/channel/UCDV_1Dz2Ixgl1nT_3DUZVFw</a></p><p>- How Postgres chooses whic ... Show More

1h 12m

Mar 2020

Easier Stream Processing On Kafka With ksqlDB

<div class="wp-block-jetpack-markdown"><h2>Summary</h2> <p>Building applications on top of unbounded event streams is a complex endeavor, requiring careful integration of multiple disparate systems that were engineered in isolation. The ksqlDB project was created to address this ... Show More

43m 36s

Mar 2024

Linux Kernel Scheduler Developer | David Vernet

<p>The linux kernel is something we all use but have you ever thought about what goes into it, well today we've got David Vernet on the show who has spent quite a bit of time focusing on one aspect, that being the scheduler.</p> <p>=========Guest Links==========</p> <p>Twitch ... Show More

1h 55m

Aug 2022

Tech job interview support group

Struggling through the tech job interview process? We feel you! On this episode, Amal, Nick & Amelia get together to discuss the various ways the interview process disappoints, share their own interview stories, and suggest ways we can improve the process for everyone. Discuss on ... Show More

1h 4m

Dec 2019

Just get started: Buying an index

Halfway through this series and we're only just getting to 'buying your first stock'.What have we been talking about... The theme of this episode is all about 'just getting started'. In the spirit of this we are introducing the concept of an index. An index is the perfect opportu ... Show More

24m 28s

Mar 2022

Enabling performance-centric engineering orgs (JS Party #216)

This week Amal and Nick are joined by Dan Shappir, a Performance Tech Lead at Next Insurance, to learn about enabling a performance-first mindset within your engineering org. Dan recently left his 7+ year tenure leading performance at Wix where he and his team improved, and m ... Show More

1h 13m

Sep 2023

Episode 486: High Performance PostgreSQL for Rails with Andrew Atkinson

If you love taking about databases, this is the episode for you. Ahead of the launch of his new book, High Performance PostgreSQL for Rails, Andrew Atkinson joined the show with special guest co-host, Pat Bair, to talk about why he wrote a book, why he focused on PostgreSQL and h ... Show More

31m 29s

Partial Indexing | Backend Engineering S...