Why do you use Ecto.Multi?

[Papillon6814]

Hello!
I’m a beginner programmer from Japan.

I’m using phoenix for my database server. In development of the database server, I have never used Ecto.Multi just because I’m not familiar with it.
I read summary of Ecto.Multi, but I don’t get when I should adopt it well.

So what I want to ask you is, Why do you use Ecto.Multi?

[Eiji]

This ebook would be really helpful for you (not only in Ecto.Multi):

The Little Ecto Cookbook (self-published) (free)

[click] The Ecto recipes were originally written for the “What’s new in Ecto 2” ebook and then made open-source by Plataformatec. Since then, the community has joined our efforts and made many contributions. The end result is this ebook, curated by Plataformatec, which includes a foreword and an exclusive chapter written by José Valim, creator of Elixir. The Plataformatec team brings an updated collection of recipes on how to best use different features of Ecto 3.1 and later. This free ebo…

It’s free and there is no sense to copy-paste it’s contents. I really recommend reading it.

[Papillon6814]

Thanks
Did you write the book?

Link in the thread says 404 page not found…

[axelson]

I’ve updated the link in that post. The new correct link is
https://dashbit.co/ebooks/the-little-ecto-cookbook

[Eiji]

@Papillon6814

Did you write the book?

Nope, but helped a bit. By e-mail I got early releases of it and found few small issues like typos or mistake in code.

@axelson

I’ve updated the link in that post. The new correct link is

Ah, right - they changed it, I heard about change to dashbit, but completely forgot about it in this topic - I have downloaded pdf on disk and not checked their pages since that. Thanks for update.

[g_kenkun]

Ecto.Multi is used to execute SQL using transactions.
A transaction is the execution of multiple concurrent SQL operations with data integrity.
If you would like to know about a book written in Japanese, please contact me.

[axelson]

@Eiji

Ah, right - they changed it, I heard about change to dashbit , but completely forgot about it in this topic - I have downloaded pdf on disk and not checked their pages since that. Thanks for update.

No problem! And it was the correct link when you initially posted the thread.

@Papillon6814

So what I want to ask you is, Why do you use Ecto.Multi?

One concrete use case I have for Ecto.Multi is creating oban (GitHub - sorentwo/oban: 💎 Robust job processing in Elixir, backed by modern PostgreSQL or SQLite3) jobs when inserting or updating associated records.

[Papillon6814]

@g_kenkun

Ecto.Multi is used to execute SQL using transactions.

Using transactions is important for developing database server as you have ever said!

I have to understand SQL and Database more.
Thank you for many answers!

[unsek]

I’ve been looking for this kind of resource. Thanks a ton!