Problem
This query could be made more efficient. We currently fetch all conversations ordered by :inserted_at, while in the UI we display them based on how recently a message was sent within it (i.e. message.sent_at).

Solution
Optimize this query to order the results by the most recently sent message associated with the conversation.

It might also be helpful to write a query to

Hi,

It'd love to try out alloy_ci . We run almost everything in kubernetes (incl. gitlab runner) and I think it would be awesome if there was a template / manifests to deploy alloy on kubernetes.
This would make trying it out for evaluation purposes much easier.
Have no strong opinions on how a k8s example templates should be packaged but these are some options that come to my mind:

• simpl

Found through review of dwyl/phoenix-ecto-append-only-log-example#11

Link currently points to https://github.com/dwyl/phoenix-ecto-append-only-log-example/pull/2/files#diff-db55bfd345510f8bbb29d36daadf7061R21, which at the time was part of a PR.

Should we now update this to https://github.com/dwyl/phoenix-ecto-append-only-log-example/blob/3eb130e103cef05ef57e5d1fcd2