System Architecture Archives » Page 2 of 5 » Alpesh Kumar

Diagram showing a supervisor coordinating research and writing workers before delivering a final response.

LangGraph

LangGraph Supervisor Tutorial: Build a Multi-Agent System

Read more

Layered AI agent architecture with a visible trajectory moving through reasoning, tools, sandbox, monitoring, and human approval controls

Artificial Intelligence

GPT-6 Astra Didn’t Break AI. It Revealed What Was Already Broken.

Read more

Diagram comparing traditional API integrations with an MCP server connecting AI clients to multiple tools

AI Agents, Software Architecture

MCP vs API: What’s the Difference, and How Do They Work Together?

Read more

The UUID Primary Key Problem That Shows Up at 200 Million Rows — a framed technical comparison shows a random UUID B-tree scattering inserts and a point lookup fanning into many cold row pages, contrasted with a time-ordered UUID path that keeps inserts and fetched pages locally clustered. Visual direction: idea: a UUID primary-key lookup can find the key quickly yet still cause extreme page reads when random insertion order scatters the B-tree and cold row pages; subject: UUID primary keys at 200 million rows; mechanism: compare random UUID insert distribution across many B-tree leaf pages with time-ordered UUID inserts concentrated at the active edge, then show a point lookup descending the index and fanning out into scattered cold data pages marked by a dense 94,000-read texture; composition: framed comparison — a generous title band across the top, with a large left diagnostic zone for random UUID scatter and a right diagnostic zone for ordered UUID locality, joined only at the bottom by one shared lookup-to-row path; palette: deep forest/moss — pale eucalyptus background, forest-green and near-black ink, muted sandstone page blocks, restrained burnt-orange I/O accents, and a small burgundy warning accent; exclusions: dark navy, neon-blue glow, floating UI cards, network nodes, generic AI circuitry, people, robots, hands, dashboards, logos, fake code, secondary readable text, decorative charts, physical-machine metaphors

System Design

The UUID Primary Key Problem That Shows Up at 200 Million Rows

Read more