Blog

System design, data pipelines, PostGIS, and stories from the field.

Scaling bharatnet video uploads to 200 TB: from server disks to R2 + presigned URLs
How we moved off a server-bound upload path that capped out at ~60 TB and rebuilt it around Cloudflare R2, direct multipart uploads, and a Supabase Edge Function as the presigned-URL provider.
23 June 20267 min read
Cost-efficient video processing at scale
How we reduced 360° video processing cost by ~30% with better architecture and resource usage.
10 February 20251 min read
PostGIS for location intelligence in practice
Using PostGIS for site selection, catchment analysis, and spatial analytics in production.
1 February 20251 min read
Designing an address-matching pipeline for Indian addresses
How we built a scalable pipeline to clean and validate Indian addresses and reduce manual verification.
15 January 20251 min read