Writings & thoughts
Deep dives into architecture, performance and developer experience, from building real products.
AI can generate SQL, but it doesn’t understand your schema or business. Here’s how a real text-to-SQL system works — and why more context can actually make AI worse.
Everything works fine with one user — until real traffic hits. Suddenly APIs slow down, databases struggle, and errors appear. This blog uncovers hidden bottlenecks like N+1 queries, connection limits, and inefficient patterns that silently break systems as they scale.
Most backend systems fail because they try to do everything synchronously. From sending emails to processing payments, blocking operations slow down your APIs and hurt user experience. This blog explores how queues and background jobs decouple work, improve reliability, and help systems scale efficiently.
Two users. One product. Both click “Buy” at the same time. What happens next? This blog dives into real-world race conditions in ecommerce systems and explains how naive implementations lead to overselling. Learn how combining reservation systems with atomic database updates ensures consistency under high concurrency.
Git feels confusing at first — too many commands, too many errors. This beginner-friendly guide teaches Git the right way: step-by-step workflow, what each command means, and how to fix common mistakes without frustration.
Follow a fictional plot through availability, booking and payment. Compare views and booking techniques, and learn why plans and collections stay separate.
Compare endpoint checks, internal metrics and SSH checks. Learn what each proves, how alerts work, and why restarts need a separate decision.
How one platform serves separate shops. Learn the storefront flow, compare routing and storage choices, and keep orders attached to the right merchant.
Already know basic Git? This guide takes you deeper — learn rebase, stash, cherry-pick, and real-world workflows to manage code cleanly and avoid common mistakes in production.