ASAakib Shah Sayedinblog.aakibshah.com.np·Jul 25 · 11 min readPostgreSQL: The Four Layers Every Backend Engineer Eventually HitsMost PostgreSQL learning material fails for the same reason. It hands you a flat list — pg_hba.conf, Patroni, SKIP LOCKED, PL/pgSQL, PgBouncer, RLS — with no sense of which layer each item lives in or01I
ASAakib Shah Sayedinblog.aakibshah.com.np·Jul 23 · 20 min readPostgreSQL Beyond SELECT *: A Working Developer's Deep DiveMost of us meet PostgreSQL through an ORM. You write prisma.user.findMany(), it works, you move on. Then one day a query that took 40ms takes 4 seconds, your disk fills up overnight, or a security rev10
ASAakib Shah Sayedinblog.aakibshah.com.np·Jul 22 · 25 min readPostgreSQL from Scratch: A Full-Stack Developer's GuideMost tutorials teach PostgreSQL by dropping you straight into SQL syntax — SELECT, INSERT, JOIN — without explaining what a relational database actually is, how the engine works underneath, or how to 10
ASAakib Shah Sayedinblog.aakibshah.com.np·Jul 21 · 10 min readPrompt Engineering for Web Developers: From Zero-Shot to Production-Grade ReliabilityYou know what temperature and tokens are. Now learn the techniques that actually change output quality — and the reliability patterns that separate a demo from a product. In the last post, we covered00
ASAakib Shah Sayedinblog.aakibshah.com.np·Jul 20 · 11 min readLLMs Explained for Web Developers: Tokens, Temperature, and Everything In BetweenA plain-English guide to the concepts and knobs behind every AI API call — written for developers who build with JavaScript, not ML PhDs. If you're a web developer in 2026, you've probably already ca00
