Prompt Engineering
& LLM Guides
Practical guides on writing better prompts, cutting token costs and building with LLM APIs, for ChatGPT, Claude and Gemini users.
Connection Pool Exhaustion: The Real Fix
Database connection pool exhaustion causes hanging requests and timeouts under load. Here is what actually causes it and how to fix your pool setup for good.
Cursor-Based Pagination for REST APIs
Offset pagination slows down and returns duplicate rows at scale. Here's why that happens and how to implement cursor-based pagination in a REST API.
PostgreSQL EXPLAIN ANALYZE With AI: A Guide
Learn to read PostgreSQL EXPLAIN ANALYZE output with AI: capture the plan, write a precise prompt, automate it in Node.js, and verify every fix.
Node.js RAG Pipeline: pgvector + OpenAI
Build a Node.js RAG pipeline with pgvector and OpenAI embeddings for grounded, source-backed AI answers without running a separate vector database.
PostgreSQL Indexing: A Practical Guide
A practical guide to PostgreSQL indexing — when to add one, which index type fits your query, and how to actually spot a slow query needing one.
Stay ahead of the curve
Get the latest prompt engineering strategies, token optimization tricks, and platform updates delivered straight to your inbox once a month. No spam.