Batch insert with Ecto

Question

I'm trying to insert 800 changesets using a multirow INSERT query with Ecto. I'm using postgres. I see that postgrex supports this now. Is it possible yet with Ecto?

I'm also open to doing this via prepared statement if that's possible.

Answer 1

Ecto 2.0 will support Repo.insert_all/3 (current latest version is 2.0.0-rc.4 which supports this), but it doesn't support inserting changesets, only raw Maps or Keyword lists, so you'll have to filter all valid changesets and extract the fields from them yourself like you would have needed to if you used the Postgrex bulk insert feature.