DB Indexes: A Misconception Story
Why adding an index does not guarantee a faster query, and how PostgreSQL access patterns, selectivity, and execution plans changed my mental model.
Avnish Kumar
AI Software Engineer
Thoughts, tutorials, and insights on building scalable AI platforms, modern web architecture, and full-stack engineering.
Why adding an index does not guarantee a faster query, and how PostgreSQL access patterns, selectivity, and execution plans changed my mental model.
Avnish Kumar
AI Software Engineer
Understanding how Vector Databases and Graph Databases work together to create long-term memory systems for AI agents.
Avnish Kumar
AI Software Engineer
A comparison between LangGraph and modern Agent SDKs for building AI applications in 2026, and when to choose each.
Avnish Kumar
AI Software Engineer
A deep dive into transitioning from simple LLM scripts to robust, observable agentic systems using LangGraph and vector search.
Avnish Kumar
AI Software Engineer
A beginner-friendly explanation of what actually happens inside ChatGPT when you ask it a question.
Avnish Kumar
AI Software Engineer