Tue, 25 January 2022 Episode 496: Bruce Momjian on Multi-Version Concurrency Control in Postgres (MVCC) This week, Postgres server developer Bruce Momjian joins host Robert Blumen for a discussion of multi-version concurrency control (MVCC) in the Postgres database. They begin with a discussion of the isolation requirement in database transactions (I in ACID); how isolation can be achieved with locking; limitations of locking; how locking limits concurrency and creates variability in query runtimes; multi-version concurrency control as a means to achieve isolation; how Postgres manages multiple versions of a row; snapshots; copy-on-write and snapshots; visibility; database transaction IDs; how tx ids, snapshots and versions interact; the need for locking when there are multiple writers; how MVCC was added to Postgres; and how to clean up unused space left over from aged-out versions. Direct download: 496-bruce-momjian-multi-version-concurrency-control-postgres.mp3 Category:Episodes -- posted at: 8:54pm CEST

Wed, 19 January 2022 Episode 495: Vaughn Vernon on Strategic Monoliths and Microservices Vaughn Vernon, author of the book “Strategic Monoliths and Microservices” discusses his book with host Akshay Manchale about strategies for purposeful architecture from the perspective of both business decision makers and technical leaders. Direct download: Episode-495-Vaughn-Vernon-on-Strategic-Monoliths-and-Microservices.mp3 Category:Episodes -- posted at: 10:10pm CEST

Wed, 12 January 2022 Episode 494: Robert Seacord on Avoiding Defects in C Programming Robert Seacord, author of Effective C, The CERT C Coding Standard and Secure Coding in C and C++, discusses why the C programming language can be insecure, the top 5 security issues and the tools and techniques you can employ to write secure code in C. Direct download: Episode-494-Robert-Seacord-on-Avoiding-Defects-in-C-Programming.mp3 Category:Episodes -- posted at: 6:49pm CEST

Wed, 12 January 2022 Episode 494: Robert Seacord on Avoiding Defects in C Programming Robert Seacord, author of Effective C, The CERT C Coding Standard and Secure Coding in C and C++, discusses why the C programming language can be insecure, the top 5 security issues and the tools and techniques you can employ to write secure code in C. Direct download: Episode-494-Robert-Seacord-on-Avoiding-Defects-in-C-Programming.mp3 Category:Episodes -- posted at: 6:49pm CEST

Tue, 4 January 2022 Episode 493: Ram Sriharsha on Vectors in Machine Learning Ram Sriharsha of Pinecone discusses the role of vectors in machine learning, a technique that lies at the heart of many of the machine learning applications we use every day. Host Philip Winston spoke with Sriharsha about the basics of vectors, vector... Direct download: Episode-493-Ram-Sriharsha-on-Vectors-in-Machine-Learning.mp3 Category:Episodes -- posted at: 10:20pm CEST