~/talk

Search-as-you-type for 54 Million Names: PostgreSQL + Django...

Talkat DjangoCon US 2026 · 2026-08-24..08-28· [databases, search]
links:none on file
slides:none on file

Built a search-as-you-type system over 54 million North Carolina court records using PostgreSQL and Django that turns 20s queries into live results under 10ms. It combines Daitch-Mokotoff + Levenshtein<=2 to broaden phonetic matches then filter false positives, annotates queries with Postgres functions wrapped as Django Funcs, and relies on text_pattern_ops B-tree + GIN indexes and COLLATE "C" for speed. A Jupyter notebook and sample app reproduce the benchmarks; trade-offs include large index size and noisy phonetic matches unless constrained.

AI-written summary · about

  1. 0:00Introduction and speakers
  2. 1:29Context on criminal record expungement
  3. 10:50Challenges with human names
  4. 15:38Demo with sample dataset
  5. 25:51Solution with fuzzy matching algorithms
  6. 27:59Live demo of search improvements
  7. 36:09Summary and key takeaways
  8. 37:58Q&A session
~/search
type to search 6,518 conferences, 143,918 speakers and 192,133 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
← →
on a talk: 5 seconds back / forward
0–9
on a talk: jump to 0%–90% of the recording
?
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.