All Articles
7 published articles
Designing a Dropbox-Like File Storage and Synchronisation System
A system-design deep dive covering content-defined chunking, block storage, and cross-device sync.
Designing a URL Shortener Like Bitly
A system design breakdown covering ID generation, caching, database replication, and high availability.
Database Partitioning in PostgreSQL: A Practical Guide to Managing Large Tables
Understanding partition keys, partition pruning, automatic record routing, and partition lifecycle in PostgreSQL.
Temporal Internals: How Durable Execution, Replay and Workflow Recovery Actually Work
How durable execution, event history replay, transfer tasks, and workflow recovery work in Temporal.
Building a Production-Grade SQL Agent with LangGraph, PostgreSQL, and Query Guardrails 🛡️
Building a production-grade SQL agent with LangGraph, PostgreSQL, and AST query guardrails.
Beyond Basic RAG: Supercharge Retrieval Quality with Hybrid Search, pgvector, BM25, and Reranking…
Supercharge retrieval quality with hybrid search using pgvector, BM25, and reranking.
Building an LLM CLI from Scratch in Python
Streaming, multi-provider support, terminal UX, and the engineering beneath an AI tool.