~/talk

Search From the Ground Up

Talkat DjangoCon US 2019 · 2019-09-22..09-27· [python, databases]
slides:none on file

A practical, code-heavy tour that shows how to add search incrementally from filters and Q objects to Postgres full-text and hosted engines, with concrete examples of using ts_vector/ts_query, ranking, stemming and stop words and advice on indexing tradeoffs. Includes working source and a Docker setup, demonstrates approaches that scale to 120,000 rows, and compares GET form filtering versus Django forms. Runs in about 25 minutes and moves quickly.

AI-written summary · about

  1. 0:00Introduction
  2. 0:52Why Search
  3. 2:36The Search Journey
  4. 3:18How Search Looks
  5. 4:20How to Start a New Project
  6. 4:35Installing Django
  7. 5:17App Configuration
  8. 5:40Models
  9. 6:00Migrations
  10. 6:24Admin
  11. 7:28Project Level URLs
  12. 8:03Template View
  13. 8:24Template Loader
  14. 9:19Search Template
  15. 9:50Search
  16. 10:26Filtering
  17. 11:11Changing Filters
  18. 11:28Queue Objects
  19. 11:53Forms
  20. 14:03Django Forms
  21. 14:33Django Forms View
  22. 14:51Django Forms Template
  23. 15:18Full Text Search
  24. 15:29This is the Journey
  25. 16:24FullText Search Features
  26. 18:23How FullText Works
  27. 19:12Data Types
  28. 20:07Query
  29. 20:38Default Operators
  30. 20:54Conclusion
  31. 21:31Search Vector
  32. 22:04Search Query
  33. 22:22Search Rank
  34. 22:52Outro
~/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.