Vishwajeet Gupta·23h agoDesigning a Dropbox-Like File Storage and Synchronisation SystemA system-design deep dive inspired by Dropbox, Google Drive and OneDrive
Vishwajeet Gupta·2d agoDesigning a URL Shortener Like BitlyA system design breakdown covering ID generation, caching, database replication, failure handling and the trade-offs behind the…
Vishwajeet Gupta·3d agoTemporal Internals: How Durable Execution, Replay and Workflow Recovery Actually WorkImagine a customer placing an order on your application.
Vishwajeet Gupta·3d agoDatabase Partitioning in PostgreSQL: A Practical Guide to Managing Large TablesUnderstanding partition keys, partition pruning, automatic record routing, and the complete lifecycle of partitions.
Vishwajeet Gupta·Sep 20Building a Production-Grade SQL Agent with LangGraph, PostgreSQL, and Query Guardrails 🛡️Giving an LLM direct access to your database feels like magic in a weekend demo. A business user types: “Show me the top 5 customers by…
Vishwajeet Gupta·Sep 16Beyond Basic RAG: Supercharge Retrieval Quality with Hybrid Search, pgvector, BM25, and Reranking…If you have spent any time in the Generative AI space recently, you already know about RAG (Retrieval-Augmented Generation). It’s the go-to…A response icon1A response icon1
Vishwajeet Gupta·Sep 9Building an LLM CLI from Scratch in PythonStreaming, multi-provider support, terminal UX, and the engineering beneath an AI tool.