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
/ sam-roberton-5030b513b
/ 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
/ gotocon
/ goto-
/ 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/GotoConf...