"manual" assocs with Ecto

So, now I have to use a database, its been a long time since I did that, but I know some SQL.
First steps were easy with Ecto+sqlite (dont even have to install a DB), but I struggle with the assocs stuff.

There is this interesting post in a thread about this:


I’d like to try this approach, but I do not really understand what to do…!?
How would the examples in the Ecto assoc guide look like with this approach?

Can we do all that (without manually writing SQL)?

Will the queries shown in the guide still work?

Use Ecto.Multi extensively or manually compose (non nested) inserts within Repo.transaction(fn -> end).


thanks, I’ll look into this.