The latest articles on DEV Community by Sofiane Baddag (@popo63301). https://dev.to/popo63301 https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F198748%2Fd1d46fa6-5abc-425b-9e1d-06264dfdc94a.jpg https://dev.to/popo63301 en Sofiane Baddag Sun, 21 Jul 2019 09:59:39 +0000 https://dev.to/popo63301/fast-ordered-model-in-phoenix-with-ectolist-25g7 https://dev.to/popo63301/fast-ordered-model-in-phoenix-with-ectolist-25g7 <p><a href="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fthepracticaldev.s3.amazonaws.com%2Fi%2Fbzuet43fkt64iwibkfb7.gif" class="article-body-image-wrapper"><img src="https://media.dev.to/dynamic/image/width=800%2Cheight=%2Cfit=scale-down%2Cgravity=auto%2Cformat=auto/https%3A%2F%2Fthepracticaldev.s3.amazonaws.com%2Fi%2Fbzuet43fkt64iwibkfb7.gif"></a></p> <h2> Why? </h2> <p>I was coding a paid video service with a system of Serie/Video. A serie has several videos ordered according to a defined order. <br> I was surprised by how longer it took me to build this feature and by the lack of solution provided by the community. As I realized that I may encounter this problem again, say, if I build a Trello clone, I thought I have to do something. </p> <p>Here comes ecto_list ! </p> <h2> What? </h2> <p>Ecto_list is both a library and a tutorial with a set of snippets that helps you build ordered model with Ecto rapidly. No LiveView involved ! </p> <h2> How does it work? </h2> <p>There is 2 ways to save the order of items: </p> <ul> <li>in the items themselves (like <code>act_as_list</code> Ruby gem) : i.e. the Videos</li> <li>in the model they belong to: i.e. the Serie.</li> </ul> <p>Ecto_list takes the latter option. Why ? Because we want to avoid making several SQL query to update all ordering for one item only and, also, <strong>we assume we preload all the items anyway</strong>. That’s why it makes sense to save the order in the model that has many items.</p> <p>This library is super easy to understand. There is one function at the moment that does the magic of ordering the items according to a defined order: <code>EctoList.ordered_items_list/2</code> . The rest is adding the right snippets at the right parts of the source code. </p> <h2> Conclusion </h2> <p>This is my first library ever ( <em>yeaah!</em> 🎉). There is still room for improvements so if you think we can add some interesting features, feel free to contribute. </p> <h3> Links: </h3> <ul> <li>ecto_list: <a href="https://github.com/popo63301/ecto_list/" rel="noopener noreferrer">https://github.com/popo63301/ecto_list/</a> </li> <li>ecto_list_demo: <a href="https://github.com/popo63301/ecto_list_demo" rel="noopener noreferrer">https://github.com/popo63301/ecto_list_demo</a> </li> </ul> elixir phoenix ecto