~/talk

Django: a Data Shovel With a Future

Talkat DjangoCon US 2014 · 2014-08-30..09-06· [django, data-engineering]
links:none on file
slides:none on file

Claims that many web UIs become bottlenecked by server-side multiway joins (often 5–12-way) and an enormous URL state space (example calculated as 75 million states). Built a Django-backed site for the New England Wildflower Society where initial design did expensive server joins; pivoted to ship per-filter JSON lists to the client and use JavaScript/underscore.js to intersect them locally. Result: no costly search URL, trivial caching (CDN/varnish + cache-control), lower server load and a site simple enough to be served statically — a true data shovel approach.

AI-written summary · about

  1. 0:00Intro
  2. 1:43Once my code is finally working
  3. 3:42Web framework history follows a similar pattern
  4. 8:42A web framework denormalizes data to documents
  5. 10:02How much data should you deliver to the client?
  6. 12:54if hard drives kept growing
  7. 17:05Subversion git/hg minimum maximum
  8. 20:09NEW ENGLAND WILD FLOWER SOCIETY
  9. 21:27Problem: dichotomous keys
  10. 26:56red flowers smooth leaves Vermont
  11. 42:48Be aware of Python's growing data toolset
  12. 46:42NumPy arrays Pandas dataframes
  13. 49:55Python is becoming an important tool for large data sets
  14. 50:43URLs are simply text code + data
  15. 51:39Views can be simple procedures
~/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.