~/talk

Making Big Datasets Searchable

Talkat BSides London 2021 · on Saturday, 2021-11-13· [databases]
links:none on file
slides:none on file

A fast API indexes Rapid7 Project Sonar DNS data so large lookups become file seeks not full-text queries: 183 GB / 1.8B records are parsed with a suffix-array parser, converted via scenaric robot, sorted, then a crowbar + Redis byte-offset index maps keys to exact file positions. Reverse-DNS and CIDR scans convert IPs to decimals and bucket offsets to avoid huge indexes. Old DB approach timed out under load; the new gRPC/HTTP server and Go streaming CLI return bulk results in under a second and sustain thousands of requests/sec.

AI-written summary · about

  1. 0:00Start
  2. 0:36What?
  3. 1:46Extremely fast DNS API
  4. 2:03Reverse DNS queries
  5. 2:35Find Subdomains
  6. 6:55Sort time!
  7. 7:56Hash maps?
  8. 9:58Demo Time?
  9. 11:16Questions?
~/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.