Advanced PostgreSQL Aggregations
Fast reference for people who already write SQL daily. It covers aggregates, ordered and filtered aggregation, statistical functions, and multi-level grouping, all on one small schema.
leeon's coding
Latest articles
Understanding MCP Servers: A Beginner's Guide
Large language models are good at reading and writing text, but on their own they can't check your calendar, query your database, or read a file on your laptop. To be useful in real work, they need a
How I Built a Real-Time AI Chatbot for Bangladeshi Motorcyclists Using Gemini 3.8 and Server-Sent Events
As generative AI transforms modern web applications, static request-and-response paradigms are quickly becoming obsolete. Today’s users expect fluid, streaming interfaces reminiscent of ChatGPT—where
Prompt Engineering for Beginners: From Simple to Smart
A friendly guide with short examples. No big words. Just clear steps.
Understanding AI Agents from First Principles
1. Start with the right question When I start to learn agent, then first I thought it could be "install framework X and run this." Then one of my friend told me that you will end up with something tha
Embeddings, Vector Search & RAG from Scratch with Node.js and PostgreSQL (pgvector)
Learn the building blocks before you touch LangChain
Generative AI Fundamentals: The Mental Model I’m Building Before Learning the Tools
Generative AI is moving quickly. Every few weeks, there seems to be a new model, framework, agent platform, vector database, automation tool, or AI development library. It is tempting to learn them on