~/talk

PROCESSING 40 TB OF CODE FROM ~10 MILLION PROJECTS WITH A DEDICATED SERVER AND GO FOR $100

Talkat DataEngBytes Sydney 2023 · on Friday, 2023-08-25· [data-engineering, go]
links:none on file
slides:none on file

Cloned and analyzed roughly 10 million projects (about 15k short) totaling 40 TB of code, using shallow git clones, SCC for language/count/complexity, and a custom Go pipeline running on a cheap dedicated Hetzner box; cloning takes ~5 weeks, processing 1 TB of JSON took 49 hours single‑threaded on spinning disk, and overall cost targets hit near Go for $100 by avoiding AWS Lambda/Athena and using a 32‑worker Go program and tarred archives.

AI-written summary · about

  1. 0:00Introduction
  2. 2:07Analyzing 10 million projects
  3. 4:14Desktop and shell script attempt
  4. 6:20AWS Lambda and API Gateway
  5. 8:46SQS and S3 processing
  6. 10:34Dedicated servers and Taco Bell
  7. 13:21Porting to Go
  8. 14:44Efficient JSON processing
  9. 16:48Fun findings
  10. 18:53Lessons learned
  11. 21:01Dedicated servers power
  12. 21:43Legal implications
  13. 22:26Future plans
~/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.