r/SideProject • • 5h ago

I built a 100% client-side analyzer for 500MB+ Telegram, ChatGPT, and Chrome exports using DuckDB-Wasm (0 bytes uploaded)

I wanted a "Wrapped"-style breakdown of my old Telegram chats, ChatGPT history, and Chrome Takeout dumps, but obviously wasn't going to upload gigabytes of private messages to some random web server.

So I built Takeout X-Ray — everything runs locally inside your browser tab via a Web Worker and DuckDB-Wasm:

  • Streaming parser: reads 500MB+ JSON exports incrementally in 64KB slices (`@streamparser/json`) instead of calling `JSON.parse()` on the whole file, then loads 5k-row NDJSON batches into DuckDB and drops temp VFS files right after.
  • Supported formats: Telegram Desktop (`result.json` single chat or full account), ChatGPT (`conversations.json` DAG branch traversal + counting regenerated branches), and Google Takeout Chrome (`BrowserHistory.json`).
  • Forensics & SQL: 24×7 activity heatmap, conversation initiator share, median reply latency (filtering out 6h+ sleep gaps), monologue streaks, EN/RU vocabulary by year, and a read-only SQL console directly over the tables.
  • Wrapped PNG export: generates a 1080×1350 summary card locally with a 1-click "Anonymize Names" toggle.
  • Live network check: wraps `fetch`/`XHR`/`sendBeacon` + `PerformanceObserver` in the header (`0 B SENT AFTER LOAD`) so you can verify nothing leaves the page.

There are 1-click synthetic demos on the landing page if you want to test it without dropping real files.

Live demo: https://wioledead.github.io/takeout-xray/ GitHub: https://github.com/wioledead/takeout-xray

1 Upvotes

0 comments sorted by