Blog | Ayush Sharma

Blog

Articles & Insights

Exploring the world of web development, AI, and modern technology

15 Articles Published

Leaving a NoSQL Backend for Postgres: How We Migrated Kakiyo Off Appwrite

We moved Kakiyo from Appwrite to PlanetScale Postgres: 40M+ rows, 35+ tables, dual writes, catch-up scripts, Better Auth, and what actually got better after cutover.

DatabasesPostgreSQLPlanetScale

September 1, 2026

Read Article

Building MCP Servers for Production: A Complete Guide

Six months of building MCP servers, distilled into one read. What MCP is, how it works, how to build one well, and the auth and validation details nobody explains until something breaks.

MCPAIModel Context Protocol

May 1, 2026

Read Article

How Video Calling Actually Works: WebRTC and the Architecture Behind Real-Time Communication

A deep dive into how apps like WhatsApp, Discord, and Zoom handle video calls. Learn how WebRTC works, what signaling and ICE servers do, and understand the differences between Peer-to-Peer, Mesh, MCU, and SFU architectures.

WebRTCSystem DesignVideo Conferencing

March 6, 2026

Read Article

Webhooks Explained: What They Are, When to Use Them, and How to Build Them Right

The complete guide to understanding webhooks. Learn how they work, when to use them, and the production patterns that prevent data loss. From basic concepts to transactional outbox patterns, with practical testing strategies.

WebhooksBackendSystem Design

January 25, 2026

Read Article

Database Indexes Explained: How They Work and When to Use Them

A comprehensive guide to understanding database indexes. Learn how they work under the hood, when to create them, and when they hurt more than they help. From B-trees to covering indexes, with practical SQL and Drizzle examples.

DatabaseIndexesSQL

January 20, 2026

Read Article

SQL vs NoSQL: Choosing the Right Database for Your Project

A practical guide to understanding SQL and NoSQL databases. Learn what they are, how they differ, and when to use each type based on your data structure, scaling needs, and project requirements.

DatabasesSQLNoSQL

January 14, 2026

Read Article

Making Your Website Visible to AI: A Practical Guide to LLM SEO

Learn how AI systems like ChatGPT and Perplexity find and cite websites. Understand robots.txt, llms.txt, sitemaps, and content structure to get your site featured in AI-generated answers.

SEOAILLM

January 10, 2026

Read Article

Load Balancing Explained: What It Is, How It Works, and When You Need It

A complete guide to understanding load balancers. Learn the techniques, algorithms, and tools to distribute traffic across servers effectively. From DNS load balancing to Caddy and building your own.

Load BalancingSystem DesignBackend

December 30, 2025

Read Article

Real-Time Communication Explained: WebSockets, Polling, SSE, and Socket.IO

The complete guide to understanding real-time web communication. Learn what each technology actually is, how it works, and when to use it. Simple explanations with real-world analogies.

WebSocketsReal-TimeSSE

December 15, 2025

Read Article

JSON Prompting: How to Get Consistent Outputs from LLMs

Learn what JSON prompting is, why it produces predictable AI responses, and how to write effective structured prompts with simple, practical examples.

AILLMPrompt Engineering

December 10, 2025

Read Article

You Might Not Need useEffect: A Complete Guide

Learn when to use useEffect, when to avoid it, and modern alternatives. Practical examples for beginners and production React code.

ReactuseEffectTanStack Query

December 2, 2025

Read Article

What's New in Prisma 7 and How to Upgrade

Prisma 7 removes Rust, delivers 90% smaller bundles, and changes how you configure projects. Here is what changed and how to upgrade from Prisma 6.

PrismaORMTypeScript

November 28, 2025

Read Article

Understanding the Data Access Layer in Next.js

A beginner-friendly guide to the Data Access Layer pattern in Next.js. Learn what it is, why you need it, and how it makes your application secure and fast.

Next.jsData Access LayerSecurity

November 27, 2025

Read Article

How Tool Calling Works in Large Language Models

Learn how LLMs use external tools and functions to perform real-world tasks beyond text generation.

AILLMTool Calling

November 21, 2025

Read Article

Next.js App Router vs Page Router: A Complete Guide

Understanding the fundamental differences between Next.js App Router and Page Router, when to use each, and how to migrate between them.

Next.jsReactWeb Development

November 20, 2025

Read Article