Building Database Applications in Elixir with Ecto

Exercise: Use Ecto's Upsert Feature

Explore how to implement Ecto's upsert functionality to manage user data in your database. Learn to insert new records or update existing ones based on unique fields, ensuring your data upload scripts can be safely rerun without errors.

We'll cover the following...

Problem statement
Code challenge

1.Introduction to This Course

2.Part I: Ecto Fundamentals

3.Get Started with Repo

4.Query Your Database

5.Connect Tables to Elixir Structs with Schemas

6.Make Changes with Changesets

7.Make Multiple Changes with Transactions and the Multi Module

8.Make Changes to the Database

Project

9.Part II: Ecto Applied

10.Add Ecto to an Elixir Application Without Phoenix

Project

11.Work with Changesets and Phoenix Forms

12.Test with Sandboxes

13.Create and Use Custom Types

14.Inserting and Updating with Upserts

15.Optimizeing Your Application Design

16.Work with Embedded Schemas

17.Creating Polymorphic Associations

18.Optimize IEx for Ecto

19.Use Schemas Without Tables

20.Tune for Performance

21.Conclusion

Exercise: Use Ecto's Upsert Feature

Problem statement