Similar to Rails `find_each`, but for Elixir's Ecto, using Stream

ecto_batch_stream.ex

defmodule EctoBatchStream do
  import Ecto.Query, only: [from: 1, from: 2]

  @batch_size 1000

  # Example:
  #
  #     query = from u in MyApp.User, select: u.email
  #     stream = EctoBatchStream.stream(MyApp.Repo, query)
  #     stream |> Stream.take(3) |> Enum.to_list # => […]
  def stream(repo, query, batch_size \\ @batch_size) do
    batches_stream = Stream.unfold(0, fn
      :done ->
        nil
      offset ->
        results = repo.all(from _ in query, offset: ^offset, limit: ^batch_size)

        if length(results) < batch_size,
          do: { results, :done },
          else: { results, offset + batch_size }
    end)

    batches_stream |> Stream.concat
  end
end