Diving into Ecto.Query
summary
Ecto.Query is presented as a full SQL-level toolbox with four components: schema changeset query repo where queries are pure structs until repo.all executes them. Examples include using fragments to query jsonb passport fields, ilike for substring email search, dynamic query composition and helpers, and a lateral join for five recent comments per post that joins posts users and limits comments to five ordered by id desc. The claim is that Ecto covers most use cases so raw SQL is rarely necessary.
AI-written summary · about
chapters (11)
- 0:00Start
- 0:29Summary
- 0:46whoami?
- 2:38Schema
- 3:32Changeset
- 5:07Modules
- 6:01Repo
- 7:25Ecto.Query 101
- 19:19Ecto. Query
- 21:54LIKE query
- 23:13JOIN query
related talks
41mEcto: A language integrated query for Elixir
35mElixir's Ecto: Functional Relational Data Access Done Right
26mComposable Queries with Ecto
37mLeveling Up With Ecto
41mEmbrace the Database With Ecto
39mEcto without SQL
42mBetter Data Access with Composable Queries
35mEcto - the Past, the Present, the Future