Database Technology: What’s Actually Changing and Why It Matters (with Ben Stopford)

Have you ever been overwhelmed by the number of databases on offer? This week we welcome database expert Ben Stopford as a guide to help us map the database landscape and make sense of it all! Join us as we embark on a journey through the history of databases, tracing the path from the RDBMs of Edgar Codd to the multitude cloud-era of options available today. Discover the strengths of various database styles and explore the tradeoffs between general-purpose databases like #PostgreSQL and #MySql or highly customised ones like #Cassandra or #Snowflake. We delve into the realm of the cloud and the opportunities it brings, both for users and the database vendors themselves. And then we examine the challenges that arise when you're forced to connect multiple databases across an organisation. Should you look at Event Sourcing? Or Event Streaming, and how exactly do they differ? Finally, we look towards the future, discussing Ben's vision of an ideal database and which programming language he would choose to build it in. -- 0:00 Intro 2:08 Where are we in Database History? 9:07 The "Best Camera" analogy 9:48 But specific needs demand specific solutions. 10:48 The gridlines of the Database Map 14:02 Columnar Databases 16:26 The specific advantages that come from cloud providers 18:16 How is the market consolidating? 19:22 Resiliency has changed 20:25 Will database builders pivot to being database providers? 23:43 Event Sourcing 25:11 The Myth of Switching Databases 27:08 ORMs 29:54 What about mixing multiple kinds of database? 34:20 Kafka, Event Sourcing and Event Streaming 38:37 Event Sourcing vs Bitemporality 41:54 What's Ben's hoped-for future? 44:45 What language would you build a database in? 48:22 Outro -- Kris on Twitter: https://twitter.com/krisajenkins Kris on LinkedIn: https://www.linkedin.com/in/krisjenkins/ Kris on Mastodon: https://mastodon.social/@krisajenkins Database icon created by Bartama Graphic - Flaticon: https://www.flaticon.com/free-icons/database Map icon created by Pixel perfect - Flaticon: https://www.flaticon.com/free-icons/map