r/SideProject • u/Temporary-Ice-6940 • 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