Erlang and SQL - Why is this so hard? - Marc Sugiyama | Code BEAM America 2024

[CodeSync]

Erlang and SQL - Why is this so hard? - Marc Sugiyama | Code BEAM America 2024

Erlang and SQL - Why is this so hard? - Marc Sugiyama | Code BEAM America 2024

This talk was recorded at Code BEAM America 2024. If you’re curious about our upcoming event, check https://codebeamamerica.com

Relational databases are powerful tools for managing data. Erlang is great at moving data around. Why is it so hard to mesh the two of them together? Many projects use relational databases in only the simplest way, through simple templating libraries, or custom code, forgoing the power of the relational database. Is there a better way? We’ll survey some of the technology pieces such as ODBC, dispel some misconceptions, and explore the awkward impedance mismatch between Erlang and relational databases.

Comments welcome! View the code-sync tag for more Code Sync talks!

[vkatsuba]

Marc, this was an amazing talk! You did a great job of breaking down the challenges of working with SQL in Erlang and highlighting the inherent differences between functional programming and relational databases. I really appreciated your insights into the ‘impedance mismatch’ and the practical approaches for dealing with it. The examples you shared and the tools you mentioned are incredibly valuable for anyone navigating this space. Thanks for sharing your expertise!