Intermediate SQL with Ecto - Dennis Beatty

Ecto makes it incredibly easy to work with slightly more advanced SQL features. There are several gotchas to dealing with some of these though. I have discovered some of these while maintaining a database of scraped data and a basic recipe app. By recreating these in a simple manner, we can easily understand the need for upserts and fragments. We will be able to explore the handling of many-to-many relationships (including a discussion of put_assoc vs cast_assoc) and talk about the best way to efficiently insert and update high volumes of records.

Audience: Intermediate

All talks thread: 0) Lonestar ElixirConf 2018 Talks