Hiren.M
  • About
  • Experience
  • Skills
  • Education
  • Blog
  • Contact

Blog

Notes on backend engineering, scalable systems, and things I've learned building production APIs.

Sep 1, 2026

How a 'Simple' CSV Export Crashed Our Node Service (And the One-Line Fix That Wasn't)

A postmortem on a memory-crashing CSV export bug, and how switching to Knex streams with Node's pipeline() fixed it for good.

nodejsbackendknexstreamsbackpressurepostmortemsystem design
Aug 26, 2026

Redis Will Go Down. Make Sure Your Node.js App Doesn't.

A practical framework for deciding what should happen when your cache, session store, or job queue can't reach Redis - classification, fallback patterns, and the client config details that actually matter in production.

redisnodejsbackendperformancescalingarchitecture
Aug 20, 2026

Database Tuning at Scale: What Actually Moves the Needle in Whitelabel Systems

Lessons from tuning PostgreSQL and MySQL in large, multi-tenant whitelabel platforms - the mistakes, the wins, and the things nobody tells you until 3 AM.

postgresqlmysqldatabaseperformancebackendscaling
Aug 19, 2026

Learning About Analytics Led Me to Parquet Files - Here's What I Found

A backend developer's dive into why Parquet is the default choice over CSV for analytics workloads - column-oriented storage, compression, schema, and a hands-on PostgreSQL export comparison.

Data AnalyticsParquetPostgreSQLNode.js

© 2026 Hiren Makwana. All rights reserved.

Designed with Glassmorphism|Senior Backend Engineer Portfolio