This video was recorded at ElixirConf EU 2022 - https://www.elixirconf.eu/ Get Your CRUD Together! | Andrew Ek - Co-founder of Arid Software ABSTRACT Most web applications, at their heart, are CRUD (Create / Read / Update / Destroy) applications wrapped around a database with some business logic mixed in. In a Ruby on Rails application, for instance, ActiveRecord provides us with a pre-built set of functions for working with our records. In Phoenix applications, we have Ecto, but it’s much less opinionated, and developers are left to their own devices. In this talk we present some opinions on how to organize these operations using Boundaries, Repos, and Queries. Talk objectives: Discuss limitations of “default” approach (a context + relying on the base application repo + lots of Ecto) Propose an alternate approach with a dedicated Repo (abstracting Ecto), Queries, and a Boundary Show how this approach can also work to provide a consistent enough interface with external services (e.g. a REST API). Target audience: This talk will be most useful to developers who have enough experience with CRUD applications that they have run across some of the pain points I discuss. • Timecodes: 00:00 - 05:45 - Intro 05:46 - 10:02 - Motivations 10:03 - 15:22 - The Data Access Layer 15:23 - 18:50 - Patterns I Like 18:51 - 25:16 - Compasable Queries 25:17 - 40:57 - The GenericRepo • Follow us on social: Twitter: https://twitter.com/ElixirConfEU LinkedIn: https://www.linkedin.com/company/27159258 • Looking for a unique learning experience? Attend the next Code Sync conference near you! See what's coming up at: https://codesync.global • SUBSCRIBE TO OUR CHANNEL https://www.youtube.com/channel/UC47eUBNO8KBH_V8AfowOWOw