Pratik Sahu
9 min
SQL: production notes
SQL is the source of truth — schema design, indexing, and explain plans drive most real performance wins.
Read article →Blog
Writing
Engineering notes on Laravel, APIs, databases, and shipping software in production.
1000 articles
Featured · 9 min read
APIsSpring Data JPA: production notes
Spring Data JPA speeds repository work while still demanding respect for fetch graphs and transactions.
Read article →Latest
Browse skills →
9 min
9 min
Laravel: production notes
Laravel is my primary framework for REST APIs, admin systems, multi-tenant apps, and integrations — with queues and even...
Read article →
11 min
Linux (Ubuntu): Observability
How **Linux (Ubuntu)** supports **Observability** in Cloud & DevOps — logs, metrics, traces, and alerting.
Read article →
11 min
GitHub: Schema migrations
How **GitHub** supports **Schema migrations** in Tools — online DDL, backfills, and zero-downtime deploys.
Read article →
11 min
Spring Data JPA: Incident runbooks
How **Spring Data JPA** supports **Incident runbooks** in Java & Spring — triage, comms, and postmortems.
Read article →
10 min
FastAPI: Feature flagging
How **FastAPI** supports **Feature flagging** in Python — gradual rollout, kill switches, and experiments.
Read article →
11 min
Pydantic: Deployment pipelines
How **Pydantic** supports **Deployment pipelines** in Python — CI/CD, staging parity, and smoke checks.
Read article →
11 min
Database Indexing: Deployment pipelines
How **Database Indexing** supports **Deployment pipelines** in Databases & Caching — CI/CD, staging parity, and smoke ch...
Read article →
10 min
OAuth2: Privacy & compliance
How **OAuth2** supports **Privacy & compliance** in API & Security — retention, consent, and audit trails.
Read article →
11 min
RBAC: Production hardening
How **RBAC** supports **Production hardening** in API & Security — release gates, rollback, and on-call readiness.
Read article →
11 min
PHP: Schema migrations
How **PHP** supports **Schema migrations** in Languages — online DDL, backfills, and zero-downtime deploys.
Read article →
11 min
Livewire: Privacy & compliance
How **Livewire** supports **Privacy & compliance** in PHP & Laravel — retention, consent, and audit trails.
Read article →