~/talk

Leveling Up With Ecto

Talkat ElixirConf 2016 · 2016-09-01..09-02· [databases]
slides:none on file

Shows concrete Ecto techniques and what actually happens when they run: how repo/query/schema/changeset map to side effects and when database calls occur, examples of composable queries and preloads to avoid N+1s, using nested inserts work to create artists albums and tracks in one go, casting and change sets without schemas for API validation, unique_constraint handling at the DB level, virtual and embedded schemas for flexible forms, and a GitHub repo with runnable sample app and code snippets.

AI-written summary · about

  1. 0:00Intro
  2. 0:25Leveling Up With Ecto
  3. 5:49Typical use
  4. 6:42Connect to another data source
  5. 7:18Add your own Repo functions
  6. 7:56Work directly with the data
  7. 9:01Low-level queries
  8. 9:24Feels a lot like SQL (in a good way)
  9. 10:49Use to interpolate
  10. 11:10Might have to think about types
  11. 12:03Queries are composable
  12. 14:02The story so far...
  13. 16:35But you don't always have to use them
  14. 18:10Associations
  15. 18:41Seeing the association records
  16. 20:02How to fix it
  17. 21:23Inserting new records is a breeze
  18. 23:19Filter and cast
  19. 24:45See if it works
  20. 25:17Validations
  21. 25:34Constraints
  22. 28:00Schemaless changesets
  23. 29:21Phoenix integration
  24. 31:55Validate, then convert
  25. 33:40Schemas don't have to have a database table
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.