Background I have to queries that return a colossal amount of data on their own. I cannot use Repo.all as doing so would materialize these into memory, which would then quickly run out. So I am trying to push as much as I can to the pSQL DB, and force the DB to do as much work as possible. My iss…

Solution(s) From what I gathered, there are two decent possible solutions to this conundrum. row_number + over One of them is using row_number() with over() from Ecto: https://hexdocs.pm/ecto/Ecto.Query.WindowAPI.html#row_number/0 Assuming I join both file_info with all_counts in a single tabl…

Devtalk

How to get the top X results of a given category using Ecto?

Backend Developer Forum Backend Questions/Help

andrea 13 February 2023 00:59 4

Will Ecto be able to support NoSQL databases in the future?

1 Like