Abhishek Singh logoAbhishek Singh
JourneyWorkBlogContact
Book a call
Abhishek Singh logoAbhishek Singh

Full stack and AI solutions engineer. I build software and automation that make businesses run faster, and write about the engineering behind it.

Explore
HomeJourneyWorkBlogContact
Writing
AI DevelopmentBackend EngineeringTech Business & Product StrategyAll posts
Get in touch

Have a project or a problem worth solving? Tell me what is slowing your business down and I will tell you honestly how I would fix it.

Contact me→
© 2026 Abhishek Singh. All rights reserved.
Available for new projects
The blog

Thoughts on building software

Long form thinking on architecture, debugging, AI in production, and the messy intersection of code and business. The trade-offs, failures, and decisions that do not fit into tutorials.

27
ARTICLES
11
TOPICS
Weekly
NEW POSTS
Stay in the loop

New posts, straight to your inbox

One email when something new goes up. No spam, unsubscribe anytime.

Showing 3 of 3 articles
Why OFFSET Pagination Broke Our API at Scale (And How Cursor Pagination Fixed It)
Backend Engineering · 7 min read
6 months ago

Why OFFSET Pagination Broke Our API at Scale (And How Cursor Pagination Fixed It)

OFFSET pagination broke our API at scale, causing slow queries and latency spikes. Learn how cursor pagination fixed performance without breaking clients.

system performancedatabase indexingapi performance+2 more
Read
A Single Missing Database Index Took Our App from 120ms to 4.8s. Here’s How I Found It
Database Engineering · 12 min read
6 months ago

A Single Missing Database Index Took Our App from 120ms to 4.8s. Here’s How I Found It

This database performance issue didn’t look like a typical failure. There were no crashes, no alerts, and no obvious slow query warnings. Locally, everything felt fast, masking the missing database index that only impacted production. As traffic increased, query performance degraded, leading to rising latency and unpredictable response times. This is exactly how hidden indexing issues silently turn into major production bottlenecks.

backend scalabilitysqldatabase optimization+4 more
Read
Fast in Dev, Slow API in Production: Fixing Your API
Backend Engineering · 8 min read
7 months ago

Fast in Dev, Slow API in Production: Fixing Your API

Your API feels instant on your laptop, then crawls the moment real users arrive. This beginner friendly tutorial explains why a fast API becomes a slow API in production, and walks you step by step through the fixes in PHP, Postgres, and the frontend.

backend scalabilitybackend architecturescalable systems+9 more
Read