How to Build a Database - Liam McLennan - CPH DevFest 2024

This talk was recorded at Copenhagen Developers Festival in Copenhagen, Denmark. #cphdevfest #ndcconferences #developer #softwaredeveloper Attend the next NDC conference near you: https://ndcconferences.com https://cphdevfest.com/ Subscribe to our YouTube channel and learn every day: / @NDC Follow our Social Media! https://www.facebook.com/ndcconferences https://twitter.com/NDC_Conferences https://www.instagram.com/ndc_conferences/ #architecture #database #javascript #typescript This session demonstrates a bunch of great ideas that make databases work, with examples from a small database written in TypeScript. Most of us use databases regularly, but have you ever wondered how they work? Despite representing fifty years of technological progress, database technology is mysterious to most people who use them, and that's sad, because databases are awesome. Non-stop academic and industrial progress, from System R to ClickHouse, has made database systems monuments to the engineering excellence our field is capable of, but rarely achieves. This presentation will explore query evaluation right through the stack, including query parsing, planning and execution. Investigating database internals is a great way to discover powerful and proven software architectures. It also helps attendees to get the most out of the database management products they are already using.