Following on from our previous look at the Query planner - we are joined again by Bruce Momjian to extend this exploration into looking how Postgres manages concurrency.
We start off by discussing some of the challenges and workarounds used in the past to handle concurrent access, particularly in the eyes of a database administrator.
We then highlight the concept of MVCC, how it works from a high-level, how Postgres implements it and the clean-up considerations that are present.
Finally, we mention how Postgres stores data in page-form, how projects such as pg_compact work to regain space and what the fill-factor is.
In this weeks episode we are joined by Jimmy Burrell and Scott Wlaschin to discuss all things functional.
We start off the show highlighting how Scott got into programming, the reasons why he is a big fan of Smalltalk, what he means by ‘Enterprise OO’ and being a Humanistic programmer.
From here we discuss how he got into FP, how the paradigm came to being, what FP is to Scott and why you should consider it.
Finally, we mention the differences between types in FP over langauges such as C, the railway track metaphor he uses to help explain FP concepts and architectural patterns that are more or less suited to FP.
In this weeks episode we have a long overdue catch-up with Lew.
We start off by discussing what he has been upto, and a certain four-legged addition to his family.
From here we move on to chat about working on a product vs. working in an agency setting, picking your battles when refactoring and not being scared to make mistakes.
Finally, we highlight how Edd has recently used personal Homebrew taps, using Android simulators for testing and Lew’s experience with Vue.js.
In this weeks episode we are joined by good friend of the show Joe Watkins.
We start off discussion with the successful release of PHP 7.1 and what is in store for Joe now as release manager for that version.
Following this, we chat about the libui and Yubico PHP wrappers he as been working on and development of a better Raspberry Pi OS.
Finally, we highlight progress made towards incorporating a JiT compiler within PHP and some interesting things you can do with Zero-width joiner’s and Emoji’s in Unicode.
In this weeks episode we start off by congratulating Mick on handing in his masters dissertation.
We then move on to discuss decision trees, ordinal regression and genetic algorithms.
Edd then mentions managing large tables in Postgres, MVCC, Fill factors and Vacuuming a table.
Finally, we touch upon testing time-dependent processes in isolation, dreaded CRM integration and sign-up processes.
Corrections: Couple of mistakes by Edd; its’ MVCC not MVVC, and any character that can’t be represented using 8 bits in PHP will have a
strlen > 1.
In this weeks second in-person episode, we start off by congratulating Fraser on his recent engagement.
We then move on to chat about setting up Kong, rate-limiting APIs and monitoring the health of an application system.
From here we discuss the final stages of Mick’s masters dissertation, highlighting the PageRank paper and the Matthew (not Mafia) effect.
Finally, we mention Edd’s trip to Silicon Milkroundabout and blog posts that he has recently had the chance to publish.
In this weeks episode Mick and Edd start off discussion with an update on Mick’s masters dissertation.
We then move on to highlight the value of getting an MVP released, and the old adage that hindsight is 20/20.
Edd then brings up how he has had the chance to revisit MyBuilder’s logging and monitoring infrastructure recently, re-accessing Severity levels along the way (embarrassingly missing out Critical in the podcast).
He also mentions how background processes used within the application have changed overtime - discussing the difference between Time-dependent and Continuous processes.
Finally, we chat about successfully introducing Supervisor into the stack and Erlang’s ‘Let it Crash’ philosophy.
In this weeks episode we are joined by Jonathan Klein to discuss his recently released Composer Pluralsight course.
We start off by discussing the problem Composer is trying to solve, followed by past attempts at trying to solve it in the PHP landscape.
Following this, we move on to discuss how the composer.json and composer.lock files work, the importance of versioning, the Semantic Versioning standard and how autoloading works.
Finally, we delve into a couple of lesser-known Composer features, such as the event life-cycle, scripts and the plugin architecture that is present.
In this weeks episode we have a long overdue catch-up with Joe Watkins.
We start off discussion with progress on PHP 7.1 and work Joe has been doing to provide an interface to libui within PHP.
We then move on to chat about a couple of interesting RFC’s that are currently under-discussion, followed by managing long-running PHP processes with Supervisor and Unix signaling.
Finally, we highlight how Garbage collection works and how PHP implements the concept to help manage memory.
In this weeks episode we start off discussion on the latest Apple event, what we think the next big product will be (the Apple Hat?!) and phone battery life woes.
We then move on to chat about immutable design considerations, controlling mutation to aid performance and being bit by values vs. references.
From here we highlight how profilers such as Blackfire are a great way of benchmarking/profiling your application - providing statistics over only your own intuitive claims.
Finally, we mention database backup strategies, AVL trees and adding AirPlay support to your Vinyl deck.