Functional Programming in…SQL? • Sam Roberton • YOW! 2019

This presentation was recorded at YOW! 2019. #GOTOcon #YOW https://yowcon.com Sam Roberton - Director of Engineering at Criteria Corp @SamRoberton RESOURCES https://www.linkedin.com/in/sam-roberton-5030b513b https://twitter.com/sroberton ABSTRACT Many real-world lots-of-business-value-providing systems use a #RelationalDB. (Even more of them should!) Often, that database is used as a dumb data store – nothing more, logically, than an ACID-compliant coordinator of multiple flat files (tables). We send it basic queries – sometimes even joining multiple tables in one query! – inserts, updates and deletes. But nothing that might strain its little brain. Often, this is a mistake: a modern relational database is the most sophisticated data-munging tool in our toolkit! We should consider doing more work in the database itself. But that's not easy to code well. How can we make our more complex SQL code easier to reason about, more reliable, and more testable? How can we make the overall system simpler? These are questions that in not-the-database contexts, we solve with functional programming techniques. Without expecting SQL to out-lambda #Haskell, are there techniques that we can borrow from functional programming and apply to improving our SQL? [...] RECOMMENDED BOOKS Charity Majors, Liz Fong-Jones & George Miranda • Observability Engineering • https://amzn.to/38scbma Kelly Shortridge & Aaron Rinehart • Security Chaos Engineering • https://www.verica.io/sce-book Nora Jones & Casey Rosenthal • Chaos Engineering • https://amzn.to/3hUmuAH Mikolaj Pawlikowski • Chaos Engineering • https://amzn.to/2SQ5Olf Russ Miles • Learning Chaos Engineering • https://amzn.to/3hCiUe8 https://twitter.com/GOTOcon https://www.linkedin.com/company/goto- https://www.facebook.com/GOTOConferences #SQL #FunctionalProgramming #SamRoberton #YOWcon Looking for a unique learning experience? Attend the next GOTO conference near you! Get your ticket at https://gotopia.tech Sign up for updates and specials at https://gotopia.tech/newsletter SUBSCRIBE TO OUR CHANNEL - new videos posted almost daily. https://www.youtube.com/user/GotoConferences/?sub_confirmation=1